Why Excel SUM Is Higher Than the Status Bar Total in WPS Spreadsheets
Question details
User needs to understand why a SUM formula returns a higher total than the status bar total in a WPS Office spreadsheet when hidden rows or columns are present.

- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- Comparing the SUM function result with the status bar total for a selected range that contains hidden rows, hidden columns, or near-zero-height rows.
- Observed behavior
- The SUM function includes hidden rows or columns, while the status bar total can exclude them, causing the SUM result to appear higher than expected.
Make sure you can see the row and column headers in your WPS Spreadsheets worksheet, and select the exact range used by the SUM formula so you can inspect hidden rows or columns.
Check and Unhide Hidden Rows or Columns in the Selected Range
Use this solution when you need to identify the hidden cells that the SUM function is including and verify the total manually.
Hidden rows, hidden columns, and rows reduced to almost zero height remain part of a normal SUM range. Unhiding them reveals the extra values that make the SUM result higher than the status bar total.
Click the cell containing the SUM formula, then review the formula bar to confirm the exact range used.
In the row number and column letter headers, check for missing numbers or letters, or row boundaries that are almost completely collapsed.
Select the rows or columns around the hidden area, right-click the row or column header, and choose Unhide. You can also click Home > Format > Hide & Unhide > Unhide Rows or Unhide Columns.
Check the newly visible values, then compare the SUM result with the status bar total to confirm they now match.

Use SUBTOTAL to Exclude Hidden or Filtered Rows from the Total
Use this solution when you want the formula total to automatically ignore hidden rows or filtered results without manually unhiding cells.
Fix SUM and Status Bar Total Mismatches in WPS Spreadsheets
Use WPS Spreadsheets to check hidden rows or columns and switch to SUBTOTAL, so your totals are accurate and match the status bar in .xlsx workbooks.
- 1. Open your workbook in WPS Spreadsheets: Launch WPS Office, open the affected .xlsx file, and go to the worksheet with the SUM formula.
- 2. Select the SUM formula range: Click the SUM cell and note the range shown in the formula bar.
- 3. Unhide hidden rows or columns: Select around the hidden headers, right-click the row or column header, and choose Unhide, or use Home > Format > Hide & Unhide.
- 4. Switch to SUBTOTAL if needed: Enter =SUBTOTAL(109, range) in the total cell to calculate only visible cells when hidden rows or filters are present.
- 5. Confirm the totals match: Compare the formula result with the status bar total after unhiding or changing the formula.

Frequently Asked Questions
Why does the status bar show a lower total than SUM in my spreadsheet?
The status bar total can exclude hidden rows or columns, while a normal SUM formula includes them. In WPS Spreadsheets, unhide the hidden cells or use SUBTOTAL(109, range) to calculate visible cells only.
How do I unhide hidden rows or columns in WPS Spreadsheets?
Select the rows or columns surrounding the hidden area, right-click the row or column header, and choose Unhide. You can also go to Home > Format > Hide & Unhide > Unhide Rows or Unhide Columns.
Which SUBTOTAL code should I use to ignore hidden rows?
Use 109 for a SUM formula that ignores manually hidden rows and filtered rows. Function code 9 excludes filtered rows but can still include manually hidden rows.
Can rows reduced to almost zero height affect SUM?
Yes. A row dragged to near-zero height is still part of a normal SUM range. Drag the row boundary to restore its height or use SUBTOTAL(109, range) to exclude it.
Can WPS Spreadsheets open Excel files that use SUM and SUBTOTAL?
Yes. WPS Spreadsheets supports Microsoft Excel .xlsx files and common Excel functions such as SUM and SUBTOTAL, so you can open, edit, and save these files without losing the formulas.




