COUNTIF

[Jane]

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

 

[Gary Brown]

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

 

[Gary Brown]

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

 

[Fredrik Wahlgren]

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), C1>0),1,0)

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

Best Regards,
Fredrik

 

[Biff]

Hi!

Try this:

=SUMPRODUCT((C1:C10>0)*(G1:G10={1,2,3}))

Biff