Thank you Roger. As soon as I convinced myself to use your example syntax
literally, i.e. (--( [hyphens for the number of conditions placed in the
outer brackets], then it was a snap.

George Papangellin
Fresno, California

"Roger Govier" wrote:

Hi George

Sumproduct will probably provide your solution, but note that you cannot
use whole column ranges as the argument.

Use something like
=SUMPRODUCT(--($B$1:$B$65535="value1"),--($C$1:$C$65535="value2"))
You can use as many sets of conditions within the outer set of brackets
as you require.
Wrap the test in quotes "Value 1" if comparing Text, or omit the quotes
and just use numbers for Numeric data.

--
Regards

Roger Govier


"George P" <George wrote in message
...
i have 4 criteria that all have to =true then sum a range. the range
to find
each criterion is a column.

I have tried sumif, if(and(and(and(and, lookup, etc.

thanks,
George