Thread: COUNTIF function when 2 conditions exist?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
 
Posts: n/a
Default COUNTIF function when 2 conditions exist?
=SUMPRODUCT(--(A2:A50=cond1),--(B2:B50=cond2),C2:C50)


--

Regards,

Peo Sjoblom


"Inquiring Minds" <Inquiring wrote in
message ...
Using EXCEL 2000, I need the COUNTIF function when I want 2 conditions in
separate columns to be counted.


Reply With QuoteReply With Quote