multiple condition formula
 

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

multiple condition formula
 

=sumproduct((a2:a2225)*(a2:a22<49))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

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

multiple condition formula
 

"cudan" wrote:
I want to add values in column A if values in column B are 25 but <49?

One way: =SUMPRODUCT((B$2:B$1025)*(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
---

multiple condition formula
 

One way:

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

--
Biff
Microsoft Excel MVP


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

multiple condition formula
 

I should have read the post more carefully

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Don Guillett" wrote in message
...
=sumproduct((a2:a2225)*(a2:a22<49))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

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

multiple condition formula
 

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)

--
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"Max" wrote:

"cudan" wrote:
I want to add values in column A if values in column B are 25 but <49?

One way: =SUMPRODUCT((B$2:B$1025)*(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
---