=SUMPRODUCT(--(CAT="1"),--(Complete="Yes"))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"MJMP" wrote in message
...
I need to generate a function that will check two different criterias
before
it adds them up.

In one column labeled "CAT" (for category), the values range from "1,"
"2",
"3", and "4." In the second column labeled "Complete," the values can
either
be "YES" or "NO."

If CAT is "1" and if Complete is "Yes," then I want that particular line
item to be added with others with the same criteria. So, if three
different
rows contained both criterias, then the value in the cell would be 3.

I hope some one out there can help me with this "simple" function!

Thanks!