Consulting | Excel
Examples

## Use SUMIF instead of D... functions

When you need to analyze a list of data then you can set up
criteria ranges and use database functions like DSUM, DAVERAGE or
DCOUNT - OR, take a shortcut and use SUMIF and COUNTIF.
These functions have built in criteria ranges, so you save
time.

=SUMIF(C16:C:45,">10.2",G16:G45) will sum all the
values in column G where column C is greater than 10.2.

=COUNTIF(C16:C45,">10.2",G16:G45) will count the
number of rows where C is greater than 10.2

##### Last modified: September 16, 2010