Forum Discussion
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 formulae
Down through the column the formula either calculates a figure or it does not dependant on other factors so sometimes its Blank or shows #N/A( however i have excluded this). The formula in Cell D6 is
IFNA(INDEX(BG12:BG12),MATCH(A6,BF12:BF12,)),"") The BG12 and BF 12 reference are a drop down list reference
I had to enter the IFNA as i had a number of cells in the same column that were not calculating as the formula did not pick up the search criteria
Can you Help in correcting the return result of #VALUE! from my =sum formula please
Regards
Mark
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.
5 Replies
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 confusion
