Sumif with two conditions?

[thiensu]

How to use "sumif" funtion in which there are tow criteria?
A B
10 1
13 2
15 3
20 12
I want calculation col B with criteria col A >10, <15.
Who help me?

[Trevor Shuttleworth]

Thiensu

=SUMPRODUCT((A1:A4>10)*(A1:A4<15)*(B1:B4))

adjust the range to suit

Regards

Trevor


"thiensu" <[email protected]> wrote in
message news:[email protected]...
>
> How to use "sumif" funtion in which there are tow criteria?
> A B
> 10 1
> 13 2
> 15 3
> 20 12
> I want calculation col B with criteria col A >10, <15.
> Who help me?
>
>
> --
> thiensu
> ------------------------------------------------------------------------
> thiensu's Profile:
> http://www.excelforum.com/member.php...o&userid=36317
> View this thread: http://www.excelforum.com/showthread...hreadid=560967
>