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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using SUMIF inside SUMPRODUCT => complex problem (suite) 1
SUMIF date criteria 3
sumif 2
Which function will shorten IF-THEN-ELSE ? 5
can you imbed a sumif 1
SUMIF start/stop 2
Counting number of rows based on mutiple criteria 2
SUMIF and AND/OR/NOT 7

Top