Sumif with two conditions?

T

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?
 
T

Trevor Shuttleworth

Thiensu

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

adjust the range to suit

Regards

Trevor
 
Top