Need Help with SUM and IF

[Drawcar3]

I have the below table. I need a formula that will sum Row 1, but only provide the sum for the cells that do not have a value in row 2. So I need the Sum on Row 1 in this circumstance to equal $80 (Because there is a value in A2, E2, H2, & L2...therefore not adding cells A1, E1, H1 & L1 to the formula). Anyone able to provide a formula that will do this properly?

Thanks so much!

[TABLE="width: 630"]
<colgroup><col width="64" style="width: 48pt;" span="12"> <col width="72" style="width: 54pt; mso-width-source: userset; mso-width-alt: 2633;"> <tbody>[TR]
[TD="class: xl67, width: 64, bgcolor: transparent"]A[/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"]B[/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"]C[/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"]D[/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"]E[/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"]F[/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"]G[/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"]H[/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"]I[/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"]J[/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"]K[/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"]L[/TD]
[TD="width: 72, bgcolor: transparent"]Sum[/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"]10[/TD]
[TD="class: xl68, bgcolor: transparent"]10[/TD]
[TD="class: xl68, bgcolor: transparent"]10[/TD]
[TD="class: xl68, bgcolor: transparent"]10[/TD]
[TD="class: xl68, bgcolor: transparent"]10[/TD]
[TD="class: xl68, bgcolor: transparent"]10[/TD]
[TD="class: xl68, bgcolor: transparent"]10[/TD]
[TD="class: xl68, bgcolor: transparent"]10[/TD]
[TD="class: xl68, bgcolor: transparent"]10[/TD]
[TD="class: xl68, bgcolor: transparent"]10[/TD]
[TD="class: xl68, bgcolor: transparent"]10[/TD]
[TD="class: xl68, bgcolor: transparent"]10[/TD]
[TD="class: xl65, bgcolor: transparent"]$120 [/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent"]12[/TD]
[TD="class: xl69, bgcolor: transparent"] [/TD]
[TD="class: xl69, bgcolor: transparent"] [/TD]
[TD="class: xl69, bgcolor: transparent"] [/TD]
[TD="class: xl69, bgcolor: transparent"]12[/TD]
[TD="class: xl69, bgcolor: transparent"] [/TD]
[TD="class: xl69, bgcolor: transparent"] [/TD]
[TD="class: xl69, bgcolor: transparent"]12[/TD]
[TD="class: xl69, bgcolor: transparent"] [/TD]
[TD="class: xl69, bgcolor: transparent"] [/TD]
[TD="class: xl69, bgcolor: transparent"] [/TD]
[TD="class: xl70, bgcolor: transparent"]12[/TD]
[TD="class: xl66, bgcolor: transparent"]$48 [/TD]
[/TR]
</tbody>[/TABLE]

 

[Joe4]

Welcome to the Board!

Try this:

=SUMIF(A2:L2,"=" & "",A1:L1)

 

[jtakw]

Hi,

Can it just be this, without the "="

=SUMIF(A2:L2,"",A1:L1)

 

[Joe4]

Can it just be this, without the "="

Yes, I apparently made it more complicated than it needed to be!

 

[Drawcar3]

Thank you all so much...this is perfect! I Was using "><" in the middle and it was not working.

 

[jtakw]

You're welcome, welcome to the forum.