OOPS...Between the 2nd and 3rd formula examples :O

"Gary Brown" wrote:

Jane,
Check out Chip Pearson's Countif With Multiple Criteria...
http://www.cpearson.com/excel/array.htm
What you're interested in starts in the paragraph between the 1st two
formula examples. Don't get shook up that it's an array formula.
HTH,
Gary Brown


"Jane" wrote:

need to a COUNT when column G contains one criteria (Grades 1, 2, or 3) AND
column C contains another critera (any units over value of 0)
thanks! jane