Sum two cells if one cell has certain value

[katiedee1625]

I am trying to sum two values (V4:W4) only if the value of V4 exceeds 0.

The formula for this is in T4, but I keep getting a #value! error, no matter how I work it.

Please Login or Register  to view this content.

V4 has a formula to count J4:K4 only if the value is >=2.

Please Login or Register  to view this content.

W4 has a formula to count L4:R4 only if any of the values are >=2.

Please Login or Register  to view this content.

The reason there are two separate formulas for J4:K4 and L4:R4 is because I cannot count L4:R4 unless this is a value of 2 or greater in at least J4 or K4.

Thanks for any input in advance!

[Sam Capricci]

for the sum if V4 is greater than 0, try this... =IF($V$4>0,SUM($V$4:$W$4),"")
not clear on what question you have on the other formulas.

[katiedee1625]

for the sum if V4 is greater than 0, try this... =IF($V$4>0,SUM($V$4:$W$4),"")
not clear on what question you have on the other formulas.

Now I see where I went wrong. Your formula works perfect. The reason for posting the other formulas is to show what was in those cells that I was trying to sum, in case my error had something to do with it.

Thank you again!!

[Sam Capricci]

You're welcome. AND, thank you for the rep!