Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
complex color fill conditions- if statements or complex formula? | Excel Discussion (Misc queries) | |||
Complex Count formula | Excel Worksheet Functions | |||
Complex count formula | Excel Discussion (Misc queries) | |||
complex count | Excel Worksheet Functions | |||
Count using complex criteria | Excel Worksheet Functions |