SUMIF and COUNTIF Tutorial

Video Tutorial: https://www.youtube.com/watch?v=UmeIVPVneHk

SUMIF and COUNTIF formulas are simple but effective formulas to aggregate specific data into a single cell. Both formulas are structured similarly.

SUMIF.png

SUMIF

There are three (3) steps to the formula, each separated by a comma.

1. Range: The range that you will base your criteria on.

2. Criteria: The criteria, or rule, that you are placing on your range. Make sure to use double quotes.

3. SUM Range: The Range that you wish to sum.

COUNTIF.png

COUNTIF

There are two (2) steps to the formula, each separated by a comma.

1. Range: The range that you will base your criteria on.

2. Criteria: The criteria, or rule, that you are placing on your range. Make sure to use double quotes.

SUMPRODUCT & SUMIFCOUNTIFMario SalazarUnique, DIstinct, Excel, Remove, Duplicates, Duplicate, MIcrosoft, data, mighty, datamighty