Forum Discussion
GWHSPS
Jan 21, 2021Copper Contributor
how to sum all rows of accounting entries which also has text entries not including invoice#s
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 forma...
mathetes
Jan 21, 2021Gold Contributor
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.