Discussion how to sum all rows of accounting entries which also has text entries not including invoice#s in Excel
https://techcommunity.microsoft.com/t5/excel/how-to-sum-all-rows-of-accounting-entries-which-also-has-text/m-p/2083591#M86722
<P>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!</P>Thu, 21 Jan 2021 18:00:33 GMTGWHSPS2021-01-21T18:00:33Zhow to sum all rows of accounting entries which also has text entries not including invoice#s
https://techcommunity.microsoft.com/t5/excel/how-to-sum-all-rows-of-accounting-entries-which-also-has-text/m-p/2083591#M86722
<P>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!</P>Thu, 21 Jan 2021 18:00:33 GMThttps://techcommunity.microsoft.com/t5/excel/how-to-sum-all-rows-of-accounting-entries-which-also-has-text/m-p/2083591#M86722GWHSPS2021-01-21T18:00:33ZRe: how to sum all rows of accounting entries which also has text entries not including invoice#s
https://techcommunity.microsoft.com/t5/excel/how-to-sum-all-rows-of-accounting-entries-which-also-has-text/m-p/2083675#M86724
<P><LI-USER uid="937938"></LI-USER> </P><P> </P><P>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.</P><P> </P><P>The sum would come down at the bottom of the column you've labelled "January"</P><P> </P><P>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.</P>Thu, 21 Jan 2021 18:24:16 GMThttps://techcommunity.microsoft.com/t5/excel/how-to-sum-all-rows-of-accounting-entries-which-also-has-text/m-p/2083675#M86724mathetes2021-01-21T18:24:16ZRe: how to sum all rows of accounting entries which also has text entries not including invoice#s
https://techcommunity.microsoft.com/t5/excel/how-to-sum-all-rows-of-accounting-entries-which-also-has-text/m-p/2083719#M86727
<P><LI-USER uid="937938"></LI-USER> </P><P>If you put in the values first and then changed the format to "Text": that won't help.</P><P>You have apply the format by going to the cells and press F2 and ENTER.</P><P> </P>Thu, 21 Jan 2021 18:29:11 GMThttps://techcommunity.microsoft.com/t5/excel/how-to-sum-all-rows-of-accounting-entries-which-also-has-text/m-p/2083719#M86727Detlef Lewin2021-01-21T18:29:11Z