SPREADSHEET HAS 1426 ROWS OF DATA

FILTER TO 213 ROWS

SUM FROM LAST TO FIRST SELECT ITEM RESULTS IN A TOTAL OF 387906.55 SUM(f210:f1426)

SUM FROM LAST TO ROW 1 RESULT IN A TOTAL OF 376748.95 SUM(F1:F1426)

THE STATUS BAR SHOW A TOTAL OF 323411.95

THE STATUS BAR TOTAL IS CORRECT

Hi jandrewn,

Based on your description, after filtering data from you table and you use the formula to sum the data, but the total result is wrong.

I suppose you wonder to sum the visible data in your table.

I suggest use the SUBTOTAL formula instead of SUM formula to get the total result as shown in the following figure.

=SUBTOTAL (109,f1:f1426)

If my understanding is incorrect, please upload a sample via OneDrive or a screenshot so that I can get more accurate solutions to this problem.

Or you could send this file to our email address:

ibsofc@microsoft.com I'd like to help you check it.

Please Note: The email subject you should use the URL or the Title Name of your case.

BTW, please use the lowercase letters in your case and title so that can attract more users to help you solve your issue.

Im glad to help you and follow up your reply.

Regards,

George Zhao
TechNet Community Support