Can someone help me create a calculation that can count using three criteria?

I got help yesterday for counting using 2 criteria. Is there a way to count using 3 criteria. I'm not having much success on my own modifying the given formulae.

I am having difficulting in counting the occurrance in an excel spreadsheet using three criteria. In the attachment is a zip of a sample spreadsheet. I want to count the number of times a person who is an E-"6" that has less than 1 year in Security, additionally count only those in a particular Department such as "Admin" or what ever I type in cell H14. I need help thank you.

Hi,

In cell H16, your formula should be :

Please Login or Register  to view this content.

HTH
Carim

=SUMPRODUCT(--(LEFT(D2:D29,6)="0 year"),--(B2:B29=6),--(C2:C29=H14))

Hi Ron,

Just added all the formulae required in the Range "Admin" ...

see attached

HTH
Carim

All,
Thank you very much. The formulaes and assistance has helped tremendously.

Glad your problem is fixed.

Thanks for the feedback

Carim