sumif with different rows won't work!?
Trying to do a sumif but not all in the same row. I want to sum row 2 and 4 and divide it by sum of row 1 and 3, but only if cells in row 2 and 4 have numbers in them.
A
row 1 100 10
row 2 50 2
row 3 100 10
row 4 25 2
So, =sum(a2:b2,a4:b4)/sumif(a2:b2,a4:b4,"0",a1:b1,a3:b3
But it won't do because of the , between b1 and a3.
Help! Thank You.
|