If this post was aimed at me, simply the messenger, your thanks should go to
the author of that site, Bob Phillips.
--
Regards,

RD

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