Home

Numbers resulting from IF formulas not being captured in column sum

AFraser13
New Contributor

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.

4 Replies
What’s your formula to calculate the sum?
Highlighted

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.

Unfortunately, that does not seem to work either. 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies