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
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
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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>
>
> --
> vincent135
> ------------------------------------------------------------------------
> vincent135's Profile:
> http://www.excelforum.com/member.php...o&userid=35373
> View this thread: http://www.excelforum.com/showthread...hreadid=551836
>
thank you very much...great help
Thanks for the feedback, Vincent.
Andy.
"vincent135" <[email protected]> wrote
in message news:[email protected]...
>
> thank you very much...great help
>
>
> --
> vincent135
> ------------------------------------------------------------------------
> vincent135's Profile:
> http://www.excelforum.com/member.php...o&userid=35373
> View this thread: http://www.excelforum.com/showthread...hreadid=551836
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks