Consulting | Excel Examples
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
=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