Jan 13 2022 01:11 AM
I have a spreadsheet where a section in a particular column just will not total up. I have a section above in the same column that totals fine but this one is just not playing ball. I can't insert a screenshot as the section is too large but its just a simple formula of =SUM(D65:D142) further up in the same column I have a cell that is giving me the total fine for =SUM(D31:D59) and then one above that too which is fine, it just seems that this particular section isn't working, I have checked the number format which is same as above.
Is there anyway I can do a reset of the cells in this section with the hope I can set it up again and it will work?
Jan 13 2022 01:14 AM
@tbland310 Perhaps the numbers in that particular range are texts. You can verify that by entering e.g. =ISNUMBER(D65) in an empty cell. What do you get?
Jan 13 2022 01:21 AM
@tbland310 Can you screenshot that? Make sure that the formula bar is included in the picture.
Jan 13 2022 01:26 AM
Jan 13 2022 01:37 AM
@tbland310 I meant a screenshot of the =ISNUMBER formula that returns #NAME?
Try =ISNUMBER(D125) as cell D125 has something in it.