Forum Discussion
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...
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.
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.
=SUMPRODUCT(—L14:L48)
The double unary (—) before the range ensures that all entries therein are converted to numbers.
Unfortunately, that does not seem to work either.