how to sum all rows of accounting entries which also has text entries not including invoice#s

%3CLINGO-SUB%20id%3D%22lingo-sub-2083591%22%20slang%3D%22en-US%22%3Ehow%20to%20sum%20all%20rows%20of%20accounting%20entries%20which%20also%20has%20text%20entries%20not%20including%20invoice%23s%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2083591%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20table%20that%20has%20text%20and%20invoice%20numbers%20and%20accounting%20total%20entries.%20How%20do%20I%20sum%20that%20row%20without%20including%20invoice%20numbers%20and%20check%20numbers%20without%20a%20complicated%20formula.%20I%20set%20the%20format%20for%20the%20invoice%20numbers%20and%20check%20numbers%20as%20text%20but%20the%20formula%20still%20includes%20them.%20Thanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2083591%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2083675%22%20slang%3D%22en-US%22%3ERe%3A%20how%20to%20sum%20all%20rows%20of%20accounting%20entries%20which%20also%20has%20text%20entries%20not%20including%20invoice%23s%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2083675%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F937938%22%20target%3D%22_blank%22%3E%40GWHSPS%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt's%20not%20really%20clear%20what%20the%20problem%20is.%20You%20sum%20(or%20should%20sum)%20the%20column%20that%20has%20the%20financial%20figures%20in%20it%3B%20your%20image%20only%20shows%20one%20row%20with%20such%20a%20number.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20sum%20would%20come%20down%20at%20the%20bottom%20of%20the%20column%20you've%20labelled%20%22January%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20would%20be%20easier%20for%20people%20here%20to%20help%20you%20if%20you'd%20attach%20a%20copy%20of%20the%20spreadsheet%20itself%2C%20rather%20than%20an%20image.%20Just%20make%20sure%20there's%20no%20proprietary%20or%20personal%20information%20on%20the%20sheet.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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!

2 Replies

@GWHSPS 

 

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.

@GWHSPS 

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.