Thread: Counting conditional cells in multiple rows
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Toppers Toppers is offline
external usenet poster
  
Posts: 4,339
Default Counting conditional cells in multiple rows
try:

=SUMPRODUCT(--(R2:R100=Condition1),--(D2:D100=condition2))

"RobDuB" wrote:

How do I go about counting cells that meet criteria from row R and row D?

Thanks from Seattle!
Reply With QuoteReply With Quote