Sumif with two conditions?
 

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

Sumif with two conditions?
 

Thiensu

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

adjust the range to suit

Regards

Trevor


"thiensu" wrote in
message ...

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