Thread: SUMIF-with 2 conditions, need to add range in 2 columns
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ashish Mathur[_2_] Ashish Mathur[_2_] is offline
external usenet poster
  
Posts: 1,766
Default 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 With QuoteReply With Quote