Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Iam using Excel 2003 and I am trying to count a row based on two criteria.
For example: I am trying to count all those rows where cell B has a value of "1" AND cell F has a value of "Completed". The COUNTIF() function appears to only accept one group of parameters. Using the COUNTIF() function twice in the cell with the + operator between them appears to add those that qualify for each criteria and the "&" appears to be giving me results I have yet to figure out. I am trying to build a summary table like below based on a worksheet with many detail records (rows) in another worksheet in the same workbook: Status Level 1 Level 2 Level 3 .... Level 10 Open 10 13 1 24 Started 9 7 3 18 Completed 5 9 12 11 Etc |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adding colour to a range of cells based on one of the cells v... | Excel Discussion (Misc queries) | |||
counting cells with conditional formatting applied | Excel Discussion (Misc queries) | |||
Counting an Array based on a calculation | Excel Discussion (Misc queries) | |||
CountIF cells are not empty | Excel Discussion (Misc queries) | |||
Counting rows based on criteria in multiple cells | Excel Discussion (Misc queries) |