View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default COUNTIF with 2 conditions/columns

I'm trying to count the number of Rainy Wednesdays. COUNTIF seems the way
to go, but clearly isn't.


For 2 or more simultaneous criteria, think: sumproduct
Eg: = sumproduct((C2:C10="Rainy")*(B2:B10="Wednesday"))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---