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!