-- is a double unary to force

--

HTH

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


"MJMP" wrote in message
...
Bob,

Thank you for the assistance. I just a have a question to clarify the
function.

What is -- ? Is that the range of cells? Or do I put the range of cells
where "CAT" and "Complete" is shown?

Thanks!

"Bob Phillips" wrote:

=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!