Jan 21 2021 10:00 AM
I have a table that has text and invoice numbers and accounting total entries. How do I sum that row without including invoice numbers and check numbers without a complicated formula. I set the format for the invoice numbers and check numbers as text but the formula still includes them. Thanks!
Jan 21 2021 10:24 AM
It's not really clear what the problem is. You sum (or should sum) the column that has the financial figures in it; your image only shows one row with such a number.
The sum would come down at the bottom of the column you've labelled "January"
It would be easier for people here to help you if you'd attach a copy of the spreadsheet itself, rather than an image. Just make sure there's no proprietary or personal information on the sheet.
Jan 21 2021 10:29 AM
If you put in the values first and then changed the format to "Text": that won't help.
You have apply the format by going to the cells and press F2 and ENTER.