--

HTH

RP
(remove nothere from the email address if mailing direct)


"Tricia S." <Tricia wrote in message
...
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