see this url
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

=====================
"Jim" wrote in message
...
Back in the old Lotus 123 days, I remember being able to use #AND# or #OR#
in
a condition statement. How is this done in Excel?

For example, if I wanted to use =SUMIF and sum only items where column A
met
criteria 1 and colum B met criteria 2, how would I do that?