Complex formula to count cells

[brett]

My spread sheet is as follows:

CDate {D} RDate {E} Subarea {J}
2/1/2012 20:51 2/1/2012 20:51 green
2/1/2012 11:45 2/2/2012 9:10 red
2/3/2012 16:00 2/7/2012 10:44 green
2/9/2012 14:27 blue

I am looking to use a formula to count the number of rows where
Subarea is green and where CDate and RDate are the same.

 

[isabelle]

hi Brett,

=SUMPRODUCT(--(A2:A100=B2:B100)*(C2:C100="green"))



--
isabelle



Le 2012-02-13 14:15, brett a écrit :