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!