Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Complex Count formula
I am looking to get a formula that count the number of rows that match some
criteria. The sample table is listed below. I would to have a formula calculate the # of rows in which values in column B =3 along with values in Column C = 0 ID RATING AMOUNT formula match 00304 4.0 (5.0) x 00299 2.5 - x 00069 2.5 2.0 01380 4.0 - x 01729 3.0 - x 01783 2.5 - x 01934 2.0 (1.0) 01901 3.8 (1.0) x 01482 3.0 (1.0) x 02076 2.5 (1.0) COUNT 5 3 7 B=3 = 5 rows C=0 = 3 rows But if you combine both criteria, there are 7 rows that match. I 'm having a difficult time figuring our how to write the formula for this. Any suggestions will be much appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Complex SUMIF/COUNT IF | Excel Discussion (Misc queries) | |||
Complex count formula | Excel Discussion (Misc queries) | |||
complex count | Excel Worksheet Functions | |||
Count using complex criteria | Excel Worksheet Functions | |||
complex count question | Excel Worksheet Functions |