Frank Kabel's reply to another post (use sUMPRODUCT. See:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
) helped. However, in order for it to work for me, I had to make sure the
first column I was evaluating did not contain numeric data. Example:

Column A quality fruit color
AA 1 apple red
AA 1 orange green
BB 1 apple yellow
BB 2 pear green

I needed to know how many Quality 1 red apples there were. The quality
column test cannot be first in the SUM(IF(....) functions. The parameters
needed to fall in the order of Color, fruit, quality OR fruit, color,
quality, but quality could not be the first test performed (with or without
quotes around the "1").

If someone knows a way around that, I'd love to entertain the suggestions.
But for now, I have my answer. Thank you, Tricia

"Tricia S." wrote:

I am 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