Sum range if cells directly above are <> ""

[kgartin]

How do I get this to work (I know it's wrong but it makes sense in MY head):

{=SUMIF(A4:D4,A3:D3<>0)*1000}

I want the range A4:D4 only to be summed where the cells directly above are <> 0.

So if

A3 = 1
B3 = 2
C3 = 0
D3 = 0

And

A4 = 300
B4 = 500
C4 = 700
D4 = 200

then the result will be 800 (A4 + B4)

 

[Joe4]

One way:

=SUMPRODUCT(--(A3:D3<>0),--(A4:D4))

 

[kgartin]

One way:

=SUMPRODUCT(--(A3:D3<>0),--(A4:D4))

Thanks! Figured it out with:

=SUMIF(D3:O3,">0",D4:O4)

Although not sure why I can't get it to work with:

=SUMIF(D3:O3,"<>""",D4:O4)

 

[kgartin]

Thanks! Figured it out with:

=SUMIF(D3:O3,">0",D4:O4)

Although not sure why I can't get it to work with:

=SUMIF(D3:O3,"<>""",D4:O4)

Aaaaaand...figured it out. Should be "<>" not "<>"""

 

[Joe4]

Your second one is checking for a non-blank entry.
If you physically have a 0 in the cells, a zero is not the same as a blank.