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

[HRule Image]

Last modified: September 16, 2010