Thread: Add a column based on criteria from 2 other columns
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ashish Mathur[_2_] Ashish Mathur[_2_] is offline
external usenet poster
  
Posts: 1,766
Default Add a column based on criteria from 2 other columns
Hi,

As an alternative, you can also use the following array formula
(Ctrl+Shift+Enter)

=sum(if((rangeA=2)*(rangeB=75),rangeC))

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"cudan" wrote in message
...
Column_A Column_B Column_C
2 75 250
2 75 500
3 76 350
4 70 1000

I want to add up column C, if column_A = 2 and column_B = 75. Can someone
help me out with this?

Thanks

Reply With QuoteReply With Quote