{"id":1838,"date":"2015-11-03T00:20:33","date_gmt":"2015-11-02T23:20:33","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=1838"},"modified":"2023-11-30T21:50:20","modified_gmt":"2023-11-30T20:50:20","slug":"excel-subtotal-function-avoid-double-counting","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-subtotal-function-avoid-double-counting\/","title":{"rendered":"Excel Subtotal Function – Avoid Double Counting"},"content":{"rendered":"

What does it do?<\/strong><\/em><\/span><\/p>\n

It returns a Subtotal in a list or database<\/p>\n

Formula breakdown:<\/strong><\/em><\/span><\/p>\n

=SUBTOTAL(function_num<\/span>, ref1<\/span>)<\/p>\n

What it means:<\/strong><\/em><\/span><\/p>\n

=SUBTOTAL(function number 1-11 includes manually-hidden rows & 101-111 excludes them<\/span>, your list or range of data<\/span>)<\/p>\n

***Go to the bottom of this post to see what each value stands for<\/em><\/p>\n

\n

The SUBTOTAL function in Excel<\/a> has many great features, like the ability to:<\/p>\n

*<\/strong> Return a SUM, AVERAGE, COUNT, COUNTA, MAX or MIN<\/strong> from your data;<\/p>\n

* Include hidden values<\/strong> within your data by entering the first argument function_num<\/em>, as values between 1-11;<\/p>\n

* Ignore\u00a0hidden values<\/strong> within your data by entering the first argument function_num<\/em>, as values between 101-111;<\/p>\n

*<\/strong> Find the SUBTOTAL of filtered values<\/strong>;<\/p>\n

*<\/strong> Ignore other SUBTOTALS that are included in your range, avoiding any double counting!<\/strong><\/p>\n

<\/h2>\n
\n
\n

Table of Contents<\/p>\n<\/span><\/div>\n