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
|