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.
Mark751075 I guess you use the semi-colon as the list separator in your Excel set-up, but what do you intend to achieve with the : and the * in the SUM formula?
: is for adding one cell to another and the * is for multiplying other added cells by the one cell.
- Woops - I typed the =sum formula wrong it should read as =sum(C6:D6*B6)
Sorry for the confusionMark751075 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