I've done this more times than I can count! The AutoSum in Excel does not restrict to the SUM functionality. Works like a charm!! Please log in again. Why Formula Is Not Working in Excel (15 Reasons with Solutions). I hope the procedures described above will be good enough to solve the problem if the SUM formula is not working and returns 0. Sum also not working. 12:47 PM Excel calculates quickly, even in a monster 10 meg spreadsheet with 30+ tabs/worksheets in the file. After youve looked through the problems, you can move on to the solutions that sound more relevant to your problem. After completing the steps above and you still cannot calculate an Auto Sum or formula, perform the following steps. Thanks, yes, using NUMBERVALUE() on every cell fixed it. This function can be used with other functions like AVERAGE, Count Numbers, Max, and Min, or to sum numeric values in multiple rows or columns values from the visible cells only using the Filter option. Misleading is not an accusation but merely indicating that the information displayed will confuse somebody who is stressed and in a hurry to sort a problem out. 2013-2022 ExcelDemy.com. Similarly,you can calculate the total attendance for each student for a different set of months. Selecting infected cells then clicking delete removes the infection. I used. This will bring up a menu with three choices. Choose the cell for displaying the output. On the topic of one file affecting others I would love to hear your expert advice on recommendations for formulas that link to independent spreadsheets on SharePoint or files used in the cloud. The macro changes the setting to Manual and it doesn't get changed back. I'm no expert but I have been using Excel for many years - many versions on many machines at home and work. ActiveCell.Formula = =ColorCount(A5:A5004,A4) is a formula I add in a VBA Macro. Let the criteria be if all students marked their attendance on all 22 days in a month; then it counts as 1, else 0. Step 6: The value in cell F14 will automatically change to 3. You can also recalculate a single cell by editing the cell and pressing Enter. In algorithms for matrix multiplication (eg Strassen), why do we say n is equal to the number of rows and not the number of elements in both matrices? Step 3:Press Enter. A lot of people have had this problem when copy/pasting from text documents and no amount of formatting will work unless the spaces are removed. Even calculating manually doesnt work. Like this: Just had this problem for a working excel sheet moved rows, all cells having type "Currency" but SUM() is not able to sum. changing to "Number" did not help - removed values and entering again + using a+b and later sum solved it (for me it looks like a bug in Excel Web, using Excel Web). Click the File tab at the top left of Excel. The number type is set to general. The steps to add the given numbers are as follows: Step 1: Select cell F2, where you wish to display the total marks. on It gives me mostly R0.00, or nothing at all. This will help prevent frustration and errors for the users of your macros. Browse other questions tagged, Start here for a quick overview of the site, Detailed answers to any questions you might have, Discuss the workings and policies of this site, Learn more about Stack Overflow the company. Yes, I know that. on How can I get all the transaction from a nft collection? Jump-start your career with our Premium A-to-Z Microsoft Excel Training Bundle from the new Gadget Hacks Shop and get lifetime access to more than 40 hours of Basic to Advanced instruction on functions, formula, tools, and more.. Buy Now (97% off) > Other worthwhile deals to check out: Find out more about the Microsoft MVP Award Program. AUTOSUM IS NOT WORKING! Strange is that the file was working perfectly yesterday and nothing change on it. From the Formula tab, choose Error Checking>Circular Reference, trace it and then fix it. Trying to match up a new seat for my bicycle and having difficulty finding one that will work. Please note that the AutoSum formula in Excel considers only the numeric values in a given range of cells. For no good reason I can discern in my own case, the problem seemed to be the internal format of the time data itself, not the formatting of the function cell (and despite the fact I have formatted the entire column of numbers to various time formats and certain math functions like discrete addition yield the expected time based results). Search. When working with large files that are slow to calculate, the constant recalculation whenever changes are made can sometimes slow your system. I am Md. Also, if I press F9 the SUM will recalculate being manually forced to. Finally, press the Enter key to automatically display the sum value in the required cell.For example, consider a table of stationery items and their respective prices.Column A lists the Stationery ItemsCell B shows the Cost of each item in $Enter the AutoSum function in cell B7. In such cases, the numbers may be in text format. Check dependent formulas, and then recalculate all formulas in all open workbooks, regardless of whether they have changed since the last recalculation. Select the Automatic Calculation option. For example, the image below shows an office inventory list, from cells B2 to B5. Here are the steps you can refer to enable automatic calculation on MS Excel: Open your workbook from Microsoft Excel. The output 23 gets displayed in cell B8, the total number of grocery items. Click the AutoSum button on either the Home or Formulas tab. However, there is one major nuance here. Drop down the menu for Calculation Options and select Automatic. Find centralized, trusted content and collaborate around the technologies you use most. True or False? I am trying to use a very simple formula which is =SUM(B9:B11). How could one outsmart a tracking implant? The formula will add only the visible cell values and ignore the values hidden due to the applied filters. If you change the calculation mode in one file, it will be changed for all open files. Welcome to my profile. Try forcing Excel to rebuild the calculation dependency tree, by pressing Ctrl+Shift+Alt+F9 and let it recalculate the whole lot. Follow these steps to change the format of your data to Number on Excel: MS Excel uses the . symbol as a decimal separator by default. The workbook has no macros, and I am using the 2016 version. Saved me a ton of screwing around looking for the fix. All you need to do is click on two keys: ALT and =. Hi Jon. But you might face instances where cells appear to have numeric values, and the AutoSum function is still not working in the required way. There is a difference between misleading information and intentionally misleading information. Excel should always be able to take into account old formatting or pop up a message about it like it did at the last big programming change. The aim is to add the scores of a sixth-grade student from different subjects present in the range of cells A2:E2 in cell F2. Also, choose the respective cell for Total No. However, I did format the column to be currency, so Excell should either have changed it or alerted me to the problem! Calculate an Average with the AutoSum Button. Did you just relate to the situation we just mentioned? I think people forget the word "THANK YOU!!!!" @Leonard__I know but that still won't work if you have spaces before the number. what's the difference between "the killing machine" and "the machine that's killing". did the job and numbers are now turned into numbers that excel consider as numbers ! The sum would appear as 0 in cell F14, though there are three months with 100% attendance. When theres a space right at the beginning of the formula, its cell will display the function instead of a result for it. Learn over 270 Excel keyboard & mouse shortcuts for Windows & Mac. Have done the following: Click on cell to show total. If you would share your file with us, then hopefully we could detect the issue and could give you the exact solution. I have =SUMsorry, that was just a typo. Thanks for the video, it helped me trouble shoot everything else that might possibly be the problem. The TRIM function will remove all extra spaces. Click on the warning sign and select the Convert to Number option. Then, click on the AutoSum option from the Home or Formulas tab. So, if you would share your Excel file with us then we could find out the issue and hope, we could give you a solution. I noticed that in the status bar appears Calculate. As I mention in the video, this was exactly what happened to my friend Brett, and he was NOT aware of it. I have to pull the data out of the table, open a new sheet, past the data, then rewrite the formula, the copy down. Here are some AutoSum in Excel examples to help you understand the function more comprehensively. The advice in this video was spot on and corrected my problem. August 27, 2021, by Read More: Sum If a Cell Contains Text in Excel (6 Suitable Formulas). How Intuit improves security, latency, and development velocity with a Site Maintenance - Friday, January 20, 2023 02:00 - 05:00 UTC (Thursday, Jan Were bringing advertisements for technology courses to Stack Overflow. 08:47 AM Press Enter and this formula comes into the cell instead of the total of the numbers in the cells. For example, the number of packets for the Oats in cell A4 is nil, and the cost mentioned in cell C4 is 0. Therefore people will sometimes switch to Manual mode while working through changes on worksheets that have a lot of data, and then will switch back. Why did OpenSSH create its own key format, and not use PKCS#8? The best answers are voted up and rise to the top, Not the answer you're looking for? The result gets displayed in a cell immediately below the column cell range and to the right of the row cell range. (0 members and 1 guests). I copied and pasted it into a Word document so I could alter it. ", I noticed that if the sum contains formulas if you have any issue with circular references they won't work, go to Formulas-->Error checking-->Circular References and fix them. You may observe a warning symbol as shown in the image below. Hey Krist, @barrymdhoIs this the only solution ie copying the values from xcel and then pasting them in .doc and repeat the process to excel? 04:51 PM. I tried other options but this is the only one which works Feb 03 2022 You need to select these keys to paste the data as values. I found this under Excel Options > Formulas just before you posted the replyhowever this was the problem so you get the answer! He was left in manual calc mode and didn't know why, or how to get Excel calculating again. Have done the following: Click on cell to show total. Site design / logo 2023 Stack Exchange Inc; user contributions licensed under CC BY-SA. All Rights Reserved. It's ok. You need to hold the ALT key and click on the = key to enter the formula automatically. BUT - the 'warning' has the option to 'Convert to number' - and that fixes it! Select B10:C11 and press Alt + = to put in two AutoSum calculations. You saved me HOURS of banging my head on my desk. What do I do? The only way this can really happen is if you change the calc mode or if a macro changes the calc mode. Set up an AutoSum on two columns. Excel is telling you (in an obscure fashion) that the values in A1 and A2 are Text. 6 Main Reasons for Excel Formula Not Working (with Solution) #1 Cells Formatted as Text. This is the first time I've noticed a problem with merged cells. When Excel is in Manual Calculation mode, the formulas in your worksheet will not calculate automatically. You can disable this feature from the Formulas tab on the menu bar. I am still having this problem and it is very frustrating. Hello, HPOTTER. Thanks for your great Blog topics they are always interesting and informative! You can download the free Excel template from here and practice on your own. Excel is fussing because you're not telling what cells to sum. Have done the following: Click on cell to show total. Deleting the spaces allowed the cell to be formatted correctly to numbers and autosum started working again. The problem is that when I try to use autosum or even manually type in to range of cells excel will not give me the sum. @Steerpike - there are definitely other ways to convert in place. I had to copy and paste the values from the new sheet back into the table. I had the same problem, it was because there was a space (invisible to the eye) after each number, so even though the cells were formatted as number, and calculations set to 'Automatic', it still wasn't calculating. Additionally, see if youve used the correct symbols, such as the equals sign and parentheses. You do not need to select the cell range. If you look at the cells where you have entered values in columns C and D, there is a space before the number was entered in, this defaults the cell to a text format, removing the space will get your sum formula to work. Maybe it's some anomaly on my machine? This technique can work well for large workbooks that are slow to calculate. This is an array formula. Heres How to Fix it, What is the Ghost of Tsushima Legends Mode, How to Turn Volume Up on Vizio TV? Changing the format has no effect. Here are the steps you can refer to enable automatic calculation on MS Excel: You may have to repair the application for Microsoft Office. In all other cases, both functions work the same. I fixed it by finding 'Change the date, time or number format' in the Start search box, clicking on Additional Settings, then changing the symbol for a decimal point to (.) Finally, insert the "=" back into the formula at the beginning. - edited Dynamic range problem I can't seem to get working properly. I've attached it below: Loan Amortization Schedule Manual Calc Example.xlsx. But to introduce the problem, insert a row 11 for Jicama. Delete the "=" at the beginning of your formula and hit enter. You will notice the Average function getting created automatically, taking the range from E2 to H2 to determine the average monthly usage for Rice, as shown below. document.getElementById( "ak_js_1" ).setAttribute( "value", ( new Date() ).getTime() ); ExcelDemy is a place where you can learn Excel, and get solutions to your Excel & Excel VBA-related problems, Data Analysis with Excel, etc. I've opened the spreadsheet on multiple different machines with the same results so it appears to be an issue with the spreadsheet itself and not Excel or the computer. Should it auto sum as the info is entered or am I expecting too much? Include cell value in SUM only if corresponding cell has certain text value, Excel SUM function not working when I have used the IF function to gain results, Excel: Replace the value in a cell if the value in another cell is higher, Adding the sum of cells from multiple tabs that may be a number O, How to see the number of layers currently selected in QGIS. Pick a budget template that best meets your project's needs and download the template. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN . Excel wont calculate the data if you use other symbols such as a comma (,) as a decimal separator. The ONLY way I can see the result is to select the cell and in the formula bar press ENTER. It is to help you to in future be more careful of the screenshot. Some have reported the value changing to 0 when running the formula or having met with an error message. In the previous sections, you saw that the AutoSum in Excel does not consider alphabetical or text values. Yay! So, make sure there arent any spaces at the start of functions. Instead, you can either (a) select the range of cells and click the Home ribbon to find the indicated format cells dropdown list or (b) select the range of cells then right-click the range and select Format (near the bottom). - edited I keep encountering this issue. You will get a practice sheet in the Excel file given above to practice the explained ways. Always keep the calculation mode to Automatic. Excel Sum Not Working? And the formula in C8 becomes: Step 6: Click the Enter key. If an Excel spreadsheet displays all its formulas within cells, the Show Formulas option is probably enabled. You can download the template here to use it instantly. ssk2021 However, sometimes Excel might not always calculate formulas automatically. -Krist. There are three calculation options in Excel. I still have my trusty TI-5320SV CALCULATOR. You can follow along using the same workbook I use in the video. on The formula in cell I2 becomes: Step 4: Press the Enter key. When he opened the same files on his work computer, they were calculating just fine because Excel was in Automatic calculation mode on that computer. I used the formula audit tool and had it point to the circular reference (which I had overlooked). Consider the following example. - edited Click the Formulas tab on the left of the . To disable that option, click the Formulas tab in Excel. I'm Asmi, and I've been writing professionally since 2020. Sum also not working! The screenshot that Haytham posted seems to indicate that clicking the Data ribbon gives you an option to change the cell format. [duplicate], Microsoft Azure joins Collectives on Stack Overflow. Very frustrating when this happens. He was telling me that he was working with a file and it wasn't recalculating the formulas as he was entering data. But it does not cover your question on best practices for renaming files, especially ones stored on cloud drives. Its in automatic in both the ribbon and in the options settings. [SOLVED] Autosum not working! Therefore, if you are using this technique with your macros, I encourage you to think about ways to mitigate this issue. Excel is amazing software. It may be helpful in some particular cases. You can also select cell range manually while using the. One issue we have is that once the file connecting links are established, its difficult to rename the files or to move the files to another subfolder. https://www.excelcampus.com/functions/vlookup-other-workbooks/. While you can see a few functions, such as Average, Count Numbers, Max, and Min, you may click on More Functions to explore the options you wish to use for your tasks. Im finding that if C1 doesnt contain a number, the summation cell returns #Value. How do I make Excel add up figures? Right-click the cell -> Format Cells -> General. What it gives me is just the formula in the cell. =SUM (C8: AD8) Have gone to File, Options, Formulas, Automatic > no response It will look the same but the sum and subtotal functions will now work on the new column. Here I will post excel related useful articles. You can now see the total value in the specific cell. One of the things hardest to spot is a space in the formula just ahead of the equals (=). First, select the cell where you want the result to get displayed.2. Using AutoSum in Excel allows users to apply the SUM function in a cell faster. Its always been a little flaky. My follow-up question would it be the same for all online Excel files? The image below shows the various functions you may access through the AutoSum button, as it is a drop-down list. When you are in Manual Calculation mode, you can force a calculation at any time using the Calculate Now button on the Formulas tab. Therefore, the setting does NOT travel with the workbook. When you turn on the computer and the first spreadsheet you open is in manual mode, if you open more spreadsheets while the first spreadsheet is open, these inherit the manual mode. OK, that seems to be the problem. Selecting the AutoSum function in Excel creates the SUM formula automatically to add the numeric values in a cell range. OMG, thank you so much. You find it on the Data tab, under the What-If Scenarios button. I downloaded a free checkbook register that I have used for a long time. However, many things could go wrong with the applications abundant syntax. This will bring up a menu with three choices. But SUM and SUMPRODUCT return zero. Transporting School Children / Bigger Cargo Bikes or Trailers. . First, select cells F2 to F3 and press CTRL + C keys. Even for very simple situations. the first tab that appears to the user when he opens Excel. I'm using Excel 2007 on Windows 7 Pro. But my computer didnt work. Formula Not Working and Showing as Text in Excel, [Fixed!] Then the cell will display calculated output when you click within the formula bar (with the cell selected) and press the Return key. On your screen shot it almost looks like the sum formula is part of the marked cells to sum. Step 2: The SUM formula will appear in the specific cell with the range of cells containing numeric values to add. FYI. Stupid sneaky little checkmark. Prepare T-accounts for Manufacturing Overhead and Work in Process. Can you explain your answer? You may follow the below steps when applying the AutoSum formula from the Formulas tab. The function returns the result in cell B7 as $125, as shown below:Thus, the AutoSum function adds all the numeric values in a given continuous range of cells. I use a Lenovo laptop with an i7 processor with 16 gigs of RAM. Just like entering letters, simply double-click on a cell to enter numbers into it. I get a similar issue while importing from a csv. Seems like there may be something wrong with just this cell, but everything looks good. Click AutoSum > cursor through the row of cells to be added. Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type. To add the January numbers in this Entertainment budget, select cell B7, the cell immediately below the column of numbers. But it doesnt happen in the latest version- Excel 365, which can happen in some earlier versions. 4. Here is a table that stores the monthly attendance information for four students, Kevin, Richard, Anna, and Jacob. I misspoke on my previous reply. It is a setting at the (Excel) application level that applies to all workbooks you have open on your computer. Also having this problem, and since it just started recently and I havent changed any settings in the files I have been literally using for years without this problem, I have to assume its something to do with a Microsoft update. Don't worry about thinking you might be rude. Now see, we got the values as numbers and the SUM formula worked properly. So, it shows a warning stating there are other numbers next to the selected cell range. The below SUM formula appears automatically.=SUM(B2:B6)Press the Enter key. . Is it possible to force Excel recognize UTF-8 CSV files automatically? Keep reading this article as we list why SUM may not work and how you can fix it! I came across this out of my own frustration - didn't see it on Google which also seems weird like I'm the only one? I was having the same symptom. For example, put 1 in a new cell, copy the new cell, then select the text-that-looks-like-a-number, paste special > multiply. excel auto sum not working correctly Excel is not adding any numbers that I enter after I've auto summed them. Post the relevant items from your journal entries to these T-accounts. I often have issue with user defined functions not calculating when not on the active sheet. But didnt work formula. The following steps will guide you to use the AutoSum in Excel shortcut: Step 1: Press ALT with = sign in the cell below the range of cells in a column. ( Excel ) application level that applies to all workbooks you have open on your own a menu with choices! Cell to Enter the formula audit tool and had it point to the Reference... Applications abundant syntax various functions you may access through the row cell.... Paste special > multiply can now see, we got the values hidden due to the,. A space in the formula, its cell will display the function of. The problems, you saw that the AutoSum button, as it is a table that stores the attendance. Worked properly nft collection A2 are Text everything looks good a single cell by editing the.. There is a formula i add in a cell range as a comma (, ) as decimal. Users of your formula and hit Enter every cell fixed it AutoSum calculations and having difficulty finding that! Excell should either have changed it or alerted me to the Solutions that sound more relevant to problem. Way i can see the total of the total of the formula its... Can also recalculate a single cell by editing the cell range and to the filters. B11 ) Formulas automatically spreadsheet with 30+ tabs/worksheets in the latest version- Excel 365, which can happen in Excel! No expert but i have =SUMsorry, that was just a typo a list... Users of your formula and hit Enter 4: press the Enter key to. 27, 2021, by Read more: SUM if a macro the! Banging my head on my desk telling what cells to SUM formula in C8:. Technique can work well for large workbooks that are slow to calculate above to practice explained. The specific cell Excel is in Manual calc mode or if a cell range message! Sum would appear as 0 in cell F14, though there are numbers. With three choices workbooks, regardless of whether they have changed since last. Image below shows the various functions you may observe a warning stating there are three months with %. Other numbers next to the situation we just mentioned values from the formula, cell. Was left in Manual calc mode and did n't know why, or nothing at all move to! Nft collection Asmi, and Jacob column of numbers the cells AutoSum button, as it is to the! Doesnt happen in the video, this was exactly what happened to friend... Fixed it C11 and press CTRL + C keys returns # value but looks... Could detect the issue and could give you the exact solution numbers next to the applied filters hidden to! Excel Options > Formulas just before you posted the replyhowever this was exactly what happened to my friend,! A ton of screwing around looking for the fix, or nothing at all using... Meets your project & # x27 ; s needs and download the template well for workbooks. Regardless of whether they have changed it or alerted me to the right of the things hardest to is... And select the cell - & gt ; General THANK you!!!!!!!... Of it used the correct symbols, such as the info is entered or am i expecting too?... Respective cell for total no same workbook i use in the specific cell of.... A1 and A2 are Text gt ; format cells - & gt ; General the cell...: C11 and press ALT + = to put in two AutoSum calculations has no macros i. And you still can not calculate automatically by suggesting possible matches as type!, what is the Ghost of Tsushima Legends mode, the Formulas tab in Excel does not alphabetical. With the range of cells containing numeric values in A1 and A2 are Text if use... Thanks for the video, this was exactly what happened to my friend Brett, and he left... Contributions licensed under CC BY-SA that clicking the data tab, under What-If! Bar press Enter and this formula comes into the table very simple formula which is =SUM (:... The left of Excel be something wrong with just this cell, copy the new sheet into... Excel ) application level that applies to all workbooks you have open on screen! With three choices the screenshot that Haytham posted seems to indicate that clicking the data ribbon gives you option. Showing as Text in Excel examples to help you understand the function instead of a result it... Your macros i7 processor with 16 gigs of RAM C8 becomes: step 6: the changing! Calculation dependency tree, by pressing Ctrl+Shift+Alt+F9 and let it recalculate the whole.! Utf-8 csv files automatically that might possibly be the same for all online Excel files first time i been. Is click on the formula in C8 becomes: step 4: press the Enter.... As numbers or am i expecting too much all online Excel files Excel file given to... Haytham posted seems to indicate that clicking the data if you change format... Just mentioned may not work and How you can move on to the applied filters i am to! Recalculate all Formulas in all open workbooks, regardless of whether they have since... 0 in cell F14 will automatically change to 3 - the 'warning ' has the option 'Convert! Left in Manual calc Example.xlsx template from here and practice on your own changing! Be good enough to solve the problem, [ fixed! and the... Formula which is =SUM ( B9: B11 ) see the result gets displayed in VBA. That the AutoSum option from the formula will appear in the formula in the specific cell with the has! A very simple formula which is =SUM ( B9: B11 ) overlooked ) transaction a... More careful of the screenshot that Haytham posted seems to indicate that clicking data! Hours of banging my head on my desk still wo n't work if you the... Would appear as 0 in cell F14, though there are three months with %. Duplicate ], Microsoft Azure joins Collectives on Stack Overflow future be more of! The text-that-looks-like-a-number, paste special > multiply large files that are slow to calculate, the show Formulas option probably... A file and it is to select the cell where you want the result to get Excel calculating.. Probably enabled up on Vizio TV tree, by Read more: SUM if a macro changes the mode. Into numbers that Excel consider as numbers Excel Options > Formulas just before you the. Mode and did n't know why, or nothing at all future be more careful of the marked cells SUM. Mitigate this issue do is click on two keys: ALT and = was! Max, or MIN there arent any spaces at the beginning encourage you to in future be more of... Not travel with the workbook has no macros, i did format the column be. Three choices functions work the same and did n't know why, or nothing at all i noticed that the... Appears to the Circular Reference ( which i had overlooked ) as equals! Overhead and work in Process following: click on cell to Enter numbers into it as i mention in formula! Shortcuts for Windows & Mac almost looks like the SUM formula is not working ( solution! Follow along using the am using the same and hit Enter using the workbook..., as it is a setting at the beginning of the numbers may be something wrong with just this,!, by pressing Ctrl+Shift+Alt+F9 and let it recalculate the whole lot me mostly R0.00, nothing... As he was entering data to think about ways to mitigate this issue down! Values in a cell Contains Text in Excel does not travel with workbook... We list why SUM may not work and How you can fix it, what is the time. I think people forget the word `` THANK you!! here is a space the! Considers only the numeric values in A1 and A2 are Text i still... Of whether they have changed it or alerted me to the right the. To practice the explained ways symbol as shown in the file consider numbers... - many versions on many machines at Home and work in Process, How to working. Gives me mostly R0.00, or MIN, which can happen in specific. Merged cells can disable this feature from the Home or Formulas tab you will get a issue. You!! then hopefully we could detect the issue and could give you the solution... > Circular excel autosum not working ( which i had overlooked ) was not aware it... This article as we list why SUM may not work and How you calculate. Sum may not work and How you can also select cell range and to selected! Gives you an option to change the calc mode formula appears automatically.=SUM (:., we got the values as numbers more: SUM if a macro changes the calc and. The fix cell immediately below the column cell range: click on cell to total. Your workbook from Microsoft Excel around the technologies you use most just like entering letters, simply double-click on cell! Share your file with us, then hopefully we could detect the issue could. Trying to use a Lenovo laptop with an Error excel autosum not working you might rude!