Thread: Need your help with formulas in excel!!
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Dave is offline
external usenet poster
  
Posts: 1,388
Default Need your help with formulas in excel!!
Hi Michelle,
Then I think it's just a matter of adding them together:

=SUMPRODUCT((B2:B28="ofc")*(C2:C28="vacant"))+SUMP RODUCT((H2:H97="ofc")*(I2:I97="vacant"))

All on one line, of course.

Regards - Dave
Reply With QuoteReply With Quote