Forum Discussion
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...
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.
Woops - I typed the =sum formula wrong it should read as =sum(C6:D6*B6)
Sorry for the confusion
Sorry for the confusion
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.
- Of Course (Doh!!) The 0 instead of the "" worked a treat
Thanks so much