Excel sum/counting issue

JanetHaw 

I understand your frustration with the Excel sum/counting issue you're facing. It's strange that the problem only occurs with data downloaded from a specific site and not with data from other sources. Let's try to troubleshoot the issue:

1. Check Excel Settings:

• Go to File > Options > General.
• Under "Display," ensure "Show formula bar" and "Show status bar" are checked.
• Under "Editing," make sure "Enable AutoSum" is checked.
• Click "Customize Status bar" and verify that the desired calculations (e.g., Sum, Average, Count) are selected.

2. Review Cell Formatting:

• Select the cells containing the data you want to summarize.
• Go to the "Home" tab and check the Number Format dropdown.
• Ensure the format is set to "Number" or "Currency" (if applicable) and not "Text." Text formatting prevents numerical calculations.

3. Disable Add-ins:

• Go to File > Options > Add-ins.
• Click "Manage" and select "COM Add-ins."
• Click "Go" and uncheck any add-ins that might be interfering with Excel's functionality.
• Restart Excel and try again.

4. Repair Excel:

• Right-click on the Excel shortcut or icon and choose "Properties."
• Go to the "Compatibility" tab.
• Click "Change settings for all users."
• Check the box "Run this program in compatibility mode for" and select "Windows 7" or "Windows 8."
• Click "Apply" and "OK."
• Restart Excel and see if the issue persists.

5. Check for Updates:

• Open Excel and go to File > Account.
• Under "Product Information," click "Check for Updates."
• Install any available updates and restart Excel.

Additional Tips:

• Create a new Excel file and try downloading the data there to see if the issue persists.
• If you have a shared network drive or cloud storage, try downloading the data to your local machine and see if the problem persists.
• Check if there are any known compatibility issues between Excel and the specific website you're using. You can search online for solutions or contact the website's support.

If none of these suggestions resolve the issue, you can consider contacting Microsoft support for further assistance. They may be able to diagnose the problem more accurately based on your specific system configuration and Excel version.

I hope this helps!