Forum Discussion

Copper Contributor

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

: is for adding one cell to another and the * is for multiplying other added cells by the one cell.

3 Replies

Mark751075
Copper Contributor
Oct 12, 2022
Woops - I typed the =sum formula wrong it should read as =sum(C6:D6*B6)

Sorry for the confusion
- 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
    Copper Contributor
    Oct 12, 2022
    Of Course (Doh!!) The 0 instead of the "" worked a treat
    
    Thanks so much

Resources