SUMIF Ranges

[aus74]

Hi

Is it possible to use a range of values within the SUMIF formula?
I need to be able to SUM the values against a range of criteria e.g
range of AB0001320-AB0001330.

Is it possible to use multiple SUMIF's within the same formula?

Thanks

Au

 

[JulieD]

Hi

check out SUMPRODUCT - i think you'll find it a better choice for multiple
criterias than SUMIF.

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


Cheers
JulieD

 

[Frank Kabel]

Hi
use SUMPRODUCT. See:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html