Thread: Count Cells that meet Criteria
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sloth Sloth is offline
external usenet poster
  
Posts: 252
Default Count Cells that meet Criteria
=SUMPRODUCT(--(A5:A10="X"),--(B5:B10="C"))

"kmason" wrote:

I want to count all the X's in Cells A5:A10 if there is a C in Cells B5:B10.
Can someone help? Thanks
Reply With QuoteReply With Quote