View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rich[_6_] Rich[_6_] is offline
external usenet poster
 
Posts: 7
Default COUNTIF with 2 conditions/columns

Hi,

Column A = Date, Column B = Day of Week , Column C= Weather (Sunny, Rainy
etc)

I know I can use COUNTIF to count the number of wednesdays in B, or the
number of Rainy's in C.

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

Help appreciated.
--
Rich
http://www.richdavies.com/online-mor...calculator.htm
http://www.richdavies.com/saving-money.htm

** Posted from http://www.teranews.com **