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:
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.