Copy down formula until blank cells

[terry3218]

Hi! I have a formula that operates on the preceding cells; now I need to enter this formula in the entire column except for the cells in column that are blank. The reason that i can't simply copy down the formula is that when it reached the blank cell it also copies the formula in that cell, and therefore, the formula in the cells that follow this cell show a value error as the formula tries to perform operation on the cell that already contains a formula. I'm including a sample file; the yellow highlighted cell is where it should be a blank, but a formula copies itself there while dragging it down.

thanks

[FDibbins]

See if this will work for you, you can copy it all the way down...
=IF(B4="","",IF(AND(C4="",D4=""),SUM(E4,F4),SUM(E4,F4,G3)))

[terry3218]

Wow. Worked like a magic. Thank you.

[FDibbins]

Happy to help