C
cudan
I want to add values in column A if values in column B are >25 but <49?
Please help. Thanks
Please help. Thanks
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Don Guillett
=sumproduct((a2:a22>25)*(a2:a22<49))
M
Max
cudan said:I want to add values in column A if values in column B are >25 but <49?
One way: =SUMPRODUCT((B$2:B$10>25)*(B$2:B$10<49),A$2:A$10)
Good? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
T
T. Valko
One way:
=SUMIF(B:B,">25",A:A)-SUMIF(B:B,">=49",A:A)
=SUMIF(B:B,">25",A:A)-SUMIF(B:B,">=49",A:A)
D
Don Guillett
I should have read the post more carefully
J
JBeaucaire
This formula will work on any size dataset, you don't have to set the range
like you do with SUMPRODUCT():
=SUMIF(B:B, ">25", A:A) - SUMIF(B:B, ">48", A:A)
like you do with SUMPRODUCT():
=SUMIF(B:B, ">25", A:A) - SUMIF(B:B, ">48", A:A)