Complex formula to count cells
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. |
Complex formula to count cells
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. |
All times are GMT +1. The time now is 08:38 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com