View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
elmer elmer is offline
external usenet poster
 
Posts: 3
Default 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.