Forum Discussion

LS228's avatar
LS228
Copper Contributor
Mar 28, 2026

How to keep the result of the formula from appearing down the column before a number is added

I wish to produce a Teams running score sheet for lawn bowls.  When each team (rink) has finished their end the score for either the H or A team is entered.  When the next end is finished again the s...
Excel on Mac
m_tarler's avatar
m_tarler
Bronze Contributor
Mar 30, 2026

I think what you want is a formula like this:

=IF( N(B10)+ N(D10), SUM(B10,C9),"" )

So basically if either B10 (Home score) or D10 (Away score) is a number then report the accumulating sum.  If not, then put in a blank ("").  For the Away it is nearly the same but summing those cells:

=IF( N(B10)+ N(D10), SUM(D10,E9),"" )

Here is the result:

I have added this option in SnowMan55's file (if it will attach for we'll see....)