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