You might like using COUNTIF

--
Don Guillett
SalesAid Software

wrote in message
ups.com...
i need to know how to calculate of the subtotal for below:

A B C D E F
Year Quater Week Department Agent Action
2005 1 1 Sales Fanny No
2005 1 1 Sales Fanny Yes
2005 1 1 Sales Fanny TBA
2005 1 1 Sales Fanny No
2005 1 1 Sales Fanny No

Subtotal for the Agent's action.
For example
Fanny - No : 3, Yes = 1...etc

Your help is much appreciated. Thanks