user Archist said:
How would I create a sum formula that always includes all cells above until a cell with text is reached.
I am working with a lengthy cost estiamte spreadsheet. The sheet is frequently has rown inserted copied and pasted. In the past this has caused problems for cells with a SUM function.
I know this is written incorrectly but something to the effect of: =SUM(Offset1,0:(IF(ISTEXT))