sumif problem

[vincent135]

is it possible to have muti-columes range in the sumif formula
e.g =sumif(a1:c5,xxx,xxx)

then have multiple criteria?
e.g =sumif(xxx, first colum equals "a" & second colum >1000, xxx)

how should i write it?

thx

 

[Guest]

Hi

You could do this using SUMPRODUCT:
=SUMPRODUCT((A2:A100="criteria")*(B2:B100="some more")*(C2:C100))
If you post exactly what you, we can help you. With SUMPRODUCT you can't use
full columns as ranges (A:A) and the ranges must be the same size.
There is some more information on this here:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

Hope this helps.
Andy.

 

[vincent135]

thank you very much...great hel

 

[Guest]

Thanks for the feedback, Vincent.

Andy.