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