by Ilker | Mar 29, 2018 | Excel Tips & Tricks
Be it for budgeting, reporting, or analysis, you can easily sum data within a date range using the SUMIFS formula. SUMIFS is an extended form of SUMIF formula where you can enter multiple criteria. Syntax =SUMIFS(values to sum range, date range, >=minimum date,...
by Ilker | Mar 28, 2018 | Excel Tips & Tricks
Do you have a data table where you need to pick all the highest, lowest, best, worst, or equal to 2? SUMIF, and its bigger brother SUMIFS formulas can help sum cells of your choice. Syntax =SUMIF(criteria range, criteria, values to sum range) =SUMIFS(values to sum...
by Ilker | Mar 27, 2018 | Excel Tips & Tricks
Using the SUM formula this way will allow your data tables to grow and include any new items by running totals. Syntax =SUM(Absolute reference, Relative reference) Steps Type SUM function with a range that contains only single cell =SUM(C3:C3) Make range’s first cell...
by Ilker | Feb 23, 2016 | Tutorial
What is a Custom Application? Custom application feature allows user to create unique user interfaces (UI) by using the flexibility of HTML and CSS combined with power of JavaScript programming language. How to create Custom UI applications Custom applications...
by Ilker | Feb 10, 2016 | Tutorial
What is a User Defined Function (UDF)? A user-defined function (UDF) is a function provided by the user of a program or environment, in a context where the usual assumption is that functions are built into the program or environment. Although Microsoft Office Excel...
