Office 365 Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2117970%22%20slang%3D%22en-US%22%3EOffice%20365%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2117970%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20used%20Office%202008%20for%20several%20years%20and%20recently%20installed%20Office%20365%20for%20Mac.%20When%20adding%20cells%20to%20a%20formula%20and%20subtracting%20cells%2C%20when%20I%20click%20enter%20it%20reverts%20back%20to%20zero.%20How%20can%20I%20get%20the%20total%20of%20the%20formula%20I%20have%20entered%3F%20Thank%20you.%3DSUM(E577%2BE405%2BE379%2BE374%2BE366%2BE369%2BE338%2BE332%2BE310%2BE286%2BE193%2BE136)-(E115%2BE107)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2117970%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2118826%22%20slang%3D%22en-US%22%3ERe%3A%20Office%20365%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2118826%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F959589%22%20target%3D%22_blank%22%3E%40George_1946%3C%2FA%3E%26nbsp%3B%2C%20great%20to%20know%20you%20sorted%20this%20out%20and%20thank%20you%20for%20the%20update.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2118569%22%20slang%3D%22en-US%22%3ERe%3A%20Office%20365%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2118569%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F959589%22%20target%3D%22_blank%22%3E%40George_1946%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMany%20thanks%20Sergei%20for%20your%20help.%20I%20did%20what%20you%20suggested%2C%20adding%20one%20cell%20at%20a%20time%20to%20the%20formula%20until%20I%20found%20the%20culprit.%20It%20was%20a%20cell%20that%20I%20was%20using%20for%20many%20years%20but%20sold%20the%20property%20last%20year%20and%20when%20I%20formatted%20the%202021%20sheet%20all%20the%20expense%20listings%20for%20the%20property%20were%20still%20listed%20and%20some%20of%20them%2C%20the%20text%20extended%20out%20past%20the%20first%20column%20for%20the%20numerical%20input.%20I%20thought%20I%20read%20somewhere%20that%20text%20in%20the%20cell%20could%20throw%20off%20the%20equation.%20So%20I%20put%20a%20zero%20in%20all%20the%201st%20column%20cells%20where%20the%20text%20was%20for%20this%20property%20and%20then%20tried%20to%20hit%20enter%20to%20get%20the%20sum.%20This%20time%20it%20worked.%20I%20now%20have%20the%20formula%20that%20I%20can%20use%20for%20all%2012%20months%20this%20year.%20You%20don't%20know%20how%20relieved%20I%20am%20and%20can't%20thank%20you%20enough%20for%20taking%20the%20time%20to%20help%20me.%20Roger%20Burke%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2118415%22%20slang%3D%22en-US%22%3ERe%3A%20Office%20365%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2118415%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGood%20idea%2C%20I'll%20do%20it%20one%20at%20a%20time%20and%20check%20where%20the%20problem%20lies.%20Thanks%20again%20and%20I'll%20report%20back%20in%20hopes%20that%20something%20may%20jog%20a%20thought!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2118338%22%20slang%3D%22en-US%22%3ERe%3A%20Office%20365%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2118338%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F959589%22%20target%3D%22_blank%22%3E%40George_1946%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESorry%2C%20without%20the%20sample%20I%20can%20say%20nothing%20more.%20Perhaps%20it%20shall%20be%20zero%3F%20Try%20to%20add%20values%20one%20by%20one%20to%20check%20what%20is%20changing.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2118092%22%20slang%3D%22en-US%22%3ERe%3A%20Office%20365%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2118092%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F959589%22%20target%3D%22_blank%22%3E%40George_1946%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOK%2C%20I%20tried%20%3DE577%2BE405%20and%20I%20got%20the%20correct%20sum.%20When%20I%20tried%20with%20all%20the%20formula%20with%20no%20()%2C%20the%20sum%20was%20zero!%3F%3F%20%26nbsp%3B%26nbsp%3B%3DE577%2BE405%2BE379%2BE374%2BE366%2BE369%2BE338%2BE332%2BE310%2BE286%2BE193%2BE136-E115-E107%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2118083%22%20slang%3D%22en-US%22%3ERe%3A%20Office%20365%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2118083%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20I%20appreciate%20your%20help.%20I'll%20try%20your%20suggestion%20and%20get%20back%20to%20you.%20Thanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2118081%22%20slang%3D%22en-US%22%3ERe%3A%20Office%20365%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2118081%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F959589%22%20target%3D%22_blank%22%3E%40George_1946%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20meant%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DE577%2BE405%2BE379%2BE374%2BE366%2BE369%2BE338%2BE332%2BE310%2BE286%2BE193%2BE136-E115-E107%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3EBut%20if%20simply%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DE577%2BE405%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3Estill%20zero%3F%3C%2FP%3E%0A%3CP%3EPerhaps%20you%20may%20provide%20small%20sample%20file%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2118067%22%20slang%3D%22en-US%22%3ERe%3A%20Office%20365%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2118067%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F959589%22%20target%3D%22_blank%22%3E%40George_1946%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eand%20the%20result%20was%20still%20zero%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2118066%22%20slang%3D%22en-US%22%3ERe%3A%20Office%20365%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2118066%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20removed%20SUM%20and%20()%20on%20first%20set%20of%20cells%20but%20left%20%26nbsp%3B-()%20at%20the%20end.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2118046%22%20slang%3D%22en-US%22%3ERe%3A%20Office%20365%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2118046%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20Sergei%2C%20are%20you%20saying%20to%20remove%20the%20SUM%20and%20()%20but%20leave%20%3D%20before%20the%20formula%20and%20try%20it%3F%20If%20so%20I%20will%20try%20it.%20Thanks%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2118028%22%20slang%3D%22en-US%22%3ERe%3A%20Office%20365%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2118028%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F959589%22%20target%3D%22_blank%22%3E%40George_1946%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDuplication%20of%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Foffice-365-excel%2Fm-p%2F2117970%22%20target%3D%22_blank%22%3EOffice%20365%20Excel%20-%20Microsoft%20Tech%20Community%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2118026%22%20slang%3D%22en-US%22%3ERe%3A%20Office%20365%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2118026%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F959589%22%20target%3D%22_blank%22%3E%40George_1946%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDuplication%20of%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Foffice-365-excel%2Fm-p%2F2117970%22%20target%3D%22_blank%22%3EOffice%20365%20Excel%20-%20Microsoft%20Tech%20Community%3C%2FA%3E%3C%2FP%3E%0A%3CP%3ESUM()%20returns%20zero%20if%20you%20have%20texts%20instead%20of%20numbers.%20Actually%20SUM()%20is%20not%20required%20here%2C%20if%20you%20remove%20it%20still%20zero%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

I've used Office 2008 for several years and recently installed Office 365 for Mac. When adding cells to a formula and subtracting cells, when I click enter it reverts back to zero. How can I get the total of the formula I have entered? Thank you.=SUM(E577+E405+E379+E374+E366+E369+E338+E332+E310+E286+E193+E136)-(E115+E107)

12 Replies

@George_1946 

Duplication of Office 365 Excel - Microsoft Tech Community

SUM() returns zero if you have texts instead of numbers. Actually SUM() is not required here, if you remove it still zero?

@Sergei Baklan 

Thank you Sergei, are you saying to remove the SUM and () but leave = before the formula and try it? If so I will try it. Thanks 

@Sergei Baklan 

I removed SUM and () on first set of cells but left  -() at the end.

@George_1946 

 

and the result was still zero 

@George_1946 

I meant

=E577+E405+E379+E374+E366+E369+E338+E332+E310+E286+E193+E136-E115-E107

But if simply

=E577+E405

still zero?

Perhaps you may provide small sample file? 

@Sergei Baklan 

 

Thanks I appreciate your help. I'll try your suggestion and get back to you. Thanks

@George_1946 

 

OK, I tried =E577+E405 and I got the correct sum. When I tried with all the formula with no (), the sum was zero!??   =E577+E405+E379+E374+E366+E369+E338+E332+E310+E286+E193+E136-E115-E107

@George_1946 

Sorry, without the sample I can say nothing more. Perhaps it shall be zero? Try to add values one by one to check what is changing.

@Sergei Baklan 

 

Good idea, I'll do it one at a time and check where the problem lies. Thanks again and I'll report back in hopes that something may jog a thought!

@George_1946 

 

Many thanks Sergei for your help. I did what you suggested, adding one cell at a time to the formula until I found the culprit. It was a cell that I was using for many years but sold the property last year and when I formatted the 2021 sheet all the expense listings for the property were still listed and some of them, the text extended out past the first column for the numerical input. I thought I read somewhere that text in the cell could throw off the equation. So I put a zero in all the 1st column cells where the text was for this property and then tried to hit enter to get the sum. This time it worked. I now have the formula that I can use for all 12 months this year. You don't know how relieved I am and can't thank you enough for taking the time to help me. Roger Burke

@George_1946 , great to know you sorted this out and thank you for the update.