How to Use Sumif Function | Excel Tagalog Tutorial
SUMIF function adds the value of the cells specified by a given condition or criteria.
In this video tutorial, we simply want to get the total number of fruit orders (Apple, Banana and Orange).
SUMIF(range, criteria, [sum_range])
The SUMIF function syntax has the following arguments:
range (FRUIT column)
The range of cells that you want to evaluate by a criteria. Cells in each range must be numbers or names, arrays, or…