If cell is blank take number shown in different cell.

[rushdenx1]

The enclosed file shows data which is added to on a daily basis, so could be any length. What I want is a formula which looks at column L. If a cell is blank then it needs to look at the value in column G (ie L15 = 161. It then adds up all the blank cell totals and puts the result in L52 (still to be resolved). If a cell in column L that was blank is subsequently filled in or vice versa then the total in L52 wants to automatically update. I would also like the same formula to apply for the blanks in column O, taking the value in column H. Any help is appreciated. Kevin.

[daddylonglegs]

Try this for L52

=SUM(L3:L50)+SUMIF(L3:L50,"",G3:G50)

[sweep]

Hi,

Do these work for you?

=SUM(L3:L50)+SUMIF(L3:L50,"",G3:G50)

and

=SUM(O3:O50)+SUMIF(O3:O50,"",H3:H50)

[rushdenx1]

Thanks for your help. However the result is not coming out right. See the enclosed file again please. The figure is L52 should be 1658. I have put the blank cell values in column U to demonstrate. The figures in cells B55, C55 and L52 should add up to the figure in A55. The figure is L52 should also reduce as the blanks are filled in until it eventually shows '0'. Not sure if having zeros in columns is causing confusion as 0 is different to a blank cell. Any help appreciated. Kevin.

[sweep]

Your original post suggested you wanted to add in column G values adjacent to blanks in column L

If a cell is blank then it needs to look at the value in column G (ie L15 = 161. It then adds up all the blank cell totals and puts the result in L52

This will total the cells in column G adjacent to blanks in column L.

=SUMIF(L3:L50,"",G3:G50)