Does anyone know to create multiple ranges and criteria within the SUMIF worksheet function?
A Anonymous Feb 9, 2005 #1 Does anyone know to create multiple ranges and criteria within the SUMIF worksheet function?
J JE McGimpsey Feb 9, 2005 #2 No. SUMIF can't accept multiple ranges and criteria. You can use SUMPRODUCT, though: =SUMPRODUCT(--(A1:A100>10), --(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_group_search?as_ugroup=*excel* for tens of thousands of examples.
No. SUMIF can't accept multiple ranges and criteria. You can use SUMPRODUCT, though: =SUMPRODUCT(--(A1:A100>10), --(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_group_search?as_ugroup=*excel* for tens of thousands of examples.
K Ken Wright Feb 9, 2005 #3 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
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
