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.

hi Brett,

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



--
isabelle



Le 2012-02-13 14:15, brett a écrit :
> 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.