I was having a similar issue and your link was very helpful and easy to follow.
Thanks,
Tulio


"Ragdyer" wrote:

Sounds like you'll need something like the Sumproduct() function.
The XL help files on this function are really *no* help.

Check out this link and then post back with any further questions:

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"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