FORMULAS
 

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.

FORMULAS
 

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.

FORMULAS
 

I'm guessing at the actual data contained in your columns, but try this:

=SUMPRODUCT((A1:A100="Atlanta")*(B1:B100="Vice
President")*(C1:C100="Active"))

You could substitute cell references for the data, so that you could enter
different criteria without having to change your actual formula:

=SUMPRODUCT((A1:A100=D1)*(B1:B100=D2)*(C1:C100=D3) )

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"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.