How to Use SumIf Function in Excel | Excel Tagalog Tutorial

How to Use SumIf Function in Excel | Excel Tagalog Tutorial



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).

Syntax
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…

Leave a Reply

Your email address will not be published. Required fields are marked *