Help with Function

I am trying to simplify my counting.

I have 3 columns that I need to count.

Column one is filled with A, B, and C's

Column two is fille with X, Y, and Z's

and Column 3 is filled with S1, S2, and S3's.

I need to figure out how to create a forumala to count all personnel that is A, X, and S1 Only.

Help please. I've been trying for over 2 hours before I decided to look it up on the net. I thought I had it figured out several times, but apparently I was wrong!

Hi Try

=SUMPRODUCT(--(A1:A20="A")*(B1:B20="X")*(C1:C20="S1"))

VBA Noob

Thank you very much, now I can track Soldiers and send up the #'s easier. thank you