=SUMPRODUCT((I2:I28="OFC")*(H2:H28="Vacant"))
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
"michelle wilson" wrote in
message ...
Yes it did - now if I also need to include I2-I28 = OFC AND H2-H28=VACANT.
I
TOOK A WHACK AT ADDING IT BUT I DIDN'T DO SOMETHING RIGHT. UUGGHHH -
THANK
YOU SO MUCH FOR YOUR HELP!
--
michelle
"Mike H" wrote:
Hi,
Does this work for you?
=SUMPRODUCT((A1:A9="ofc")*(B1:B9="vacant"))
Mike
"michelle wilson" wrote:
I have 2 columns one for type and one for physical. I need to count
how many
total but only the counting those that are typed as "ofc" AND with the
physical as "vacant".
I have no idea how to do this PLEASE HELP!!
--
michelle