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

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

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

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

In some other column, insert

=IF(AND(OR(G1=1,G1=2,G1=3), C10),1,0)

At the end of this column, use the SUM function.

Best Regards,
Fredrik

Hi!

Try this:

=SUMPRODUCT((C1:C100)*(G1:G10={1,2,3}))

Biff

-----Original Message-----
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
.