sumif
 

Does anyone know to create multiple ranges and criteria within the SUMIF
worksheet function?

No. SUMIF can't accept multiple ranges and criteria.

You can use SUMPRODUCT, though:

=SUMPRODUCT(--(A1:A10010), --(B1:B100<30), C1:C100)

(see http://www.mcgimpsey.com/excel/doubleneg.html for an explananation
of the "--").

You can search the archives:

http://groups.google.com/advanced_gr...ugroup=*excel*

for tens of thousands of examples.


In article ,
Anonymous wrote:

Does anyone know to create multiple ranges and criteria within the SUMIF
worksheet function?

Take a look here for a great explanation of the SUMPRODUCT function, as well
as examples of it's use.

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

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Anonymous" wrote in message
...
Does anyone know to create multiple ranges and criteria within the SUMIF
worksheet function?