Conditional Sum & Count  
 

This useful tool allows you to sum and count data regarding to conditions specified in a criteria table.

We will show this tool's utility through examples.

SUMIF
COUNTIF