| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiple condition formula
I want to add values in column A if values in column B are 25 but <49?
Please help. Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 --- |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 --- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I set up a multiple condition formula? | Excel Worksheet Functions | |||
| Multiple if condition formula required | Excel Discussion (Misc queries) | |||
| Multiple Scenario Condition Formula | Excel Worksheet Functions | |||
| Multiple Condition Formula | Excel Worksheet Functions | |||
| Multiple Condition Sumif Formula | Excel Worksheet Functions | |||
Linear Mode
