| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF-with 2 conditions, need to add range in 2 columns
Column a
Column b Column c Column d If column d = "specific" and column a = "mary", would like to add columns b and c Please help! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SUMIF-with 2 conditions, need to add range in 2 columns
Try this:
=SUMPRODUCT((A1:A10="Mary")*(D1:D10="Specific")*B1 :C10) -- Biff Microsoft Excel MVP "nursemlb" wrote in message ... Column a Column b Column c Column d If column d = "specific" and column a = "mary", would like to add columns b and c Please help! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SUMIF-with 2 conditions, need to add range in 2 columns
Hi
Try this: =SUMPRODUCT(--(A1:A6="mary"),--(D1:D6="specific"),B1:B6+C1:C6) If this helps please check the yes button. -- Thanks, Shane Devenshire "nursemlb" wrote: Column a Column b Column c Column d If column d = "specific" and column a = "mary", would like to add columns b and c Please help! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SUMIF-with 2 conditions, need to add range in 2 columns
Hi,
you can also try this array formula (Ctrl+Shift+Enter) =sum(if((D1:D10="specific")*(A1:A10="Mary"),B1:C10 )) -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "nursemlb" wrote in message ... Column a Column b Column c Column d If column d = "specific" and column a = "mary", would like to add columns b and c Please help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SumIF full columns, multiple conditions | Excel Discussion (Misc queries) | |||
| want sumif function's range to evaluate 2 columns | Excel Worksheet Functions | |||
| count all the columns in a range with certain conditions | Excel Discussion (Misc queries) | |||
| SUMIF using two columns in both Range and Criteria | Excel Discussion (Misc queries) | |||
| SUMIF using two columns in both Range and Criteria | Excel Worksheet Functions | |||
Linear Mode
