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!

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!

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!

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!