Formula for totaling a column containing formulas , but only need those cells are not blank

%3CLINGO-SUB%20id%3D%22lingo-sub-2556876%22%20slang%3D%22en-US%22%3EFormula%20for%20totaling%20a%20column%20containing%20formulas%20%2C%20but%20only%20need%20those%20cells%20are%20not%20blank%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2556876%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20sum%20a%20column%20which%20contains%20formulas%20and%20has%20returned%20a%20value%3B%20the%20remainder%20of%20the%20spreadsheet%20remains%20blank.%3C%2FP%3E%3CP%3EThese%20are%20the%20formulas%20in%20the%20spreadsheet.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Angela_Reinhart_0-1626456640133.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F296449i6A4D7E5D5B678554%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Angela_Reinhart_0-1626456640133.png%22%20alt%3D%22Angela_Reinhart_0-1626456640133.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThis%20is%20what%20it%20looks%20like%20with%20the%20formula's%20hidden.%3C%2FP%3E%3CP%3EWhere%20it%20states%20%23REF!%2C%20this%20is%20where%20I%20want%20it%20to%20total%20the%20costs%20to%20date.%3C%2FP%3E%3CP%3EI%20can't%20find%20the%20formula%20to%20do%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Angela_Reinhart_1-1626456776208.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F296450i2B0BADE03BB5E691%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Angela_Reinhart_1-1626456776208.png%22%20alt%3D%22Angela_Reinhart_1-1626456776208.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2556876%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2557297%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20for%20totaling%20a%20column%20containing%20formulas%20%2C%20but%20only%20need%20those%20cells%20are%20not%20blank%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2557297%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1105521%22%20target%3D%22_blank%22%3E%40Angela_Reinhart%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EA%20picture%20does%20not%20help%20me%20personally%2C%26nbsp%3B%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3Esince%20i%20am%20not%20very%20fluent%20in%20the%20language%20either%2C%20want%20not%20to%20talk%20about%20the%20automatic%20translation%20%3A).%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22UdTY9%20Yb6eTe%22%3E%3CDIV%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EWith%20your%20confidence%2C%20I%20recommend%20that%20you%20insert%20a%20file%20without%20sensitive%20data.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EAt%20the%20same%20time%20knowing%20the%20Excel%20version%20and%20the%20operating%20system%20would%20be%20an%20advantage.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EBenefit%20for%20everyone%2C%20for%20you%20to%20get%20a%20quick%20and%20accurate%20answer%20and%20for%20the%20helpers%20to%20save%20time%20and%20also%20to%20help%20other%20users.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EHere%20you%20will%20find%20some%20rules%20of%20the%20forum%2C%20quickly%20listed.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EIt's%20worth%20taking%20a%20look.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fwelcome-to-your-excel-discussion-space%2Fm-p%2F2204395%22%20target%3D%22_self%22%3EWelcome%20to%20your%20Excel%20discussion%20space!%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EThank%20you%20for%20your%20patience%20and%20understanding%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3ENikolinoDE%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2557383%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20for%20totaling%20a%20column%20containing%20formulas%20%2C%20but%20only%20need%20those%20cells%20are%20not%20blank%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2557383%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1105521%22%20target%3D%22_blank%22%3E%40Angela_Reinhart%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EMost%20probably%20one%20of%20formulae%20in%20X9%3AX400%20has%20wrong%20reference%2C%20thus%20sum%20of%20them%20also%20returns%20same%20error.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I am trying to sum a column which contains formulas and has returned a value; the remainder of the spreadsheet remains blank.

These are the formulas in the spreadsheet.

Angela_Reinhart_0-1626456640133.png

This is what it looks like with the formula's hidden.

Where it states #REF!, this is where I want it to total the costs to date.

I can't find the formula to do this.

 

Angela_Reinhart_1-1626456776208.png

 

2 Replies

@Angela_Reinhart 

A picture does not help me personally, since i am not very fluent in the language either, want not to talk about the automatic translation :).

 

With your confidence, I recommend that you insert a file without sensitive data.

At the same time knowing the Excel version and the operating system would be an advantage.

Benefit for everyone, for you to get a quick and accurate answer and for the helpers to save time and also to help other users.

 

Here you will find some rules of the forum, quickly listed. It's worth taking a look.

Welcome to your Excel discussion space!

 

Thank you for your patience and understanding

 

NikolinoDE

@Angela_Reinhart 

Most probably one of formulae in X9:X400 has wrong reference, thus sum of them also returns same error.