Thread: How do I count cells with specific value?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Guntars Guntars is offline
external usenet poster
  
Posts: 22
Default How do I count cells with specific value?
Thank you all, for all your suggestions and solutions, I think I am getting
better at array formulas, this is what I come up with€¯
{=SUMPRODUCT(--(A1:A8="ONE")*(B1:F8="Y"))}



Reply With QuoteReply With Quote