SUMIF and COUNTIF

By Neil Shorney

If required, Excel is able to add or count only records which agree with a statement. These formulas are quick-and-easy and structured as follows:

=SUMIF(range,criteria,sumrange)
=SUMIF(B2:B9,"Printer",D2:D10)

SUMIF will sum a column if the corresponding cell in another column is true. COUNTIF will count the number of records which are true.

=COUNTIF(range,criteria)
=COUNTIF(B2:B9,”Laptop”)