FORMULAS

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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!
=====================================================

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.
 
Back
Top