View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sheeloo[_3_] Sheeloo[_3_] is offline
external usenet poster
 
Posts: 1,805
Default Add a column based on criteria from 2 other columns

Enter anywhere other than the sum range

=Sumproduct(--(a1:a100=2),--(b1:b100=75),(c1:c100))

Adjust 100 to the last row you want to include in your sum.

"cudan" wrote:

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