One way would be to use a Pivot Table
Another is =SUMPRODUCT(--(A1:A100="Atlanta"),--(B1:B100=Vice
President"),--(C1:C100="Active")
Adjust ranges as needed (all must be same size). Do not use A:A as range
with SUMPRODUCT
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"jbressma" wrote in message
...
I cannot figure out if I need to do a COUNT, COUNTIF, or what.....But
basically I am working with a spreadsheet and need to count a total number
if
ALL THREE Values hold true. In simpler terms:

COLUMN A=OFFICE
COLUMN B=TITLE
COLUMN C=ACTIVE/INACTIVE

I need to know the total # of people in the Atlanta office (A), who are a
Vice President (B), who are ACTIVE (C).

Hope this is clear.