View Single Post
  #1   Report Post  
Tricia S.
 
Posts: n/a
Default counting cells (COUNTIF) based on two or more criteria

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