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