Forum Discussion

Mark751075's avatar
Mark751075
Copper Contributor
Oct 12, 2022
Solved

Disregard a fomulaed cell that i need to calculate in a =sum function

Hi    I have a #VALUE in a cell where i have entered the following Formula  =sum(C6;D6:* B6)   The reason for the #VALUE! is most likely that Although cell D6 shows a figure it is produced from a...
Formulas and Functions
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Oct 12, 2022

    Mark751075 Then take the *6 outside the SUM function.

    =SUM(C6:D6)*B6 should work.

     

    Or perhaps, change the "" in the IFNA function to the number 0.

     

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Oct 12, 2022

Mark751075 Then take the *6 outside the SUM function.

=SUM(C6:D6)*B6 should work.

 

Or perhaps, change the "" in the IFNA function to the number 0.

 

Mark751075's avatar
Mark751075
Copper Contributor
Oct 12, 2022
Of Course (Doh!!) The 0 instead of the "" worked a treat

Thanks so much

Resources