SUMIF-with 2 conditions, need to add range in 2 columns

[nursemlb]

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!

 

[T. Valko]

Try this:

=SUMPRODUCT((A1:A10="Mary")*(D110="Specific")*B1:C10)

 

[ShaneDevenshire]

Hi

Try this:

=SUMPRODUCT(--(A1:A6="mary"),--(D16="specific"),B1:B6+C1:C6)


If this helps please check the yes button.

 

[Ashish Mathur]

Hi,

you can also try this array formula (Ctrl+Shift+Enter)

=sum(if((D110="specific")*(A1:A10="Mary"),B1:C10))

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com