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]](../images/div.gif){kind=small}