Click here for great value web hosting.

ALL ABOUT OFFICE

HOME

ACCESS

EXCEL

WORD

OUTLOOK

POWERPOINT




Search for
 

help


EXCEL

Using Conditional Aggregate Functions

The tests that you apply in an IF function can be added to the aggregate functions COUNT and SUM to count or sum only values that meet a certain condition.  Click the links to learn more about these functions:

SUMIF

COUNTIF

If you want to apply more complicated conditions to the data you want to aggregate then you should use Excel's database functions.

Click here to return to the Excel index.

webmaster@allaboutoffice.co.uk