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 not being captured in the total at the bottom of the column. The cells are formatted to 'accounting' so it is not a text format problem.

Formulas and Functions
    • 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.

Resources