Feb 28 2019 06:28 AM
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.
Feb 28 2019 08:28 AM
Mar 04 2019 05:50 AM
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.
Mar 04 2019 06:00 AM
Mar 04 2019 09:09 AM
Unfortunately, that does not seem to work either.