multiple condition formula

[cudan]

I want to add values in column A if values in column B are >25 but <49?
Please help. Thanks

 

[Don Guillett]

=sumproduct((a2:a22>25)*(a2:a22<49))

 

[Max]

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. Valko]

One way:

=SUMIF(B:B,">25",A:A)-SUMIF(B:B,">=49",A:A)

 

[Don Guillett]

I should have read the post more carefully

 

[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)