Forum Discussion

AFraser13's avatar
AFraser13
Copper Contributor
Feb 28, 2019

Numbers resulting from IF formulas not being captured in column sum

Can anyone help with my excel problem? I have created an accounting spreadsheet in Excel with If formulas to pre-populate future date cells. However, when the numbers show up in the cells, they are n...
Formulas and Functions
Twifoo's avatar
Twifoo
Silver Contributor
Feb 28, 2019
What’s your formula to calculate the sum?
AFraser13's avatar
AFraser13
Copper Contributor
Mar 04, 2019

I used a basic sum formula

i.e.   =SUM(L14:L48)

My fear is that the 'customized formula cell' is not being read as a number and therefore not being included in the column total. Which to me seems illogical in a spreadsheet if I am trying to pull in dollar amounts for specific weeks of the month.

  • Twifoo's avatar
    Twifoo
    Silver Contributor
    Mar 04, 2019
    Ensure that all entries in L14:L48 are numbers. Is your sum formula located in L49? Do you mean some cells in L14:L48 are not included in the sum? Try this formula:
    =SUMPRODUCT(—L14:L48)
    The double unary (—) before the range ensures that all entries therein are converted to numbers.
    • AFraser13's avatar
      AFraser13
      Copper Contributor
      Mar 04, 2019

      Unfortunately, that does not seem to work either. 

Resources