12-07-2020 08:59 AM
12-07-2020 09:16 AM - edited 12-07-2020 09:22 AM
@ehoward73401 Are you adding Autosum to a structured table? If so, "my" Excel defaults to =SUBTOTAL(109,......), which is basically the same as SUM, though it excludes hidden (filtered out) rows
If you Autosum a regular range it should give you =SUM(........).