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
.