# Calculating totals in a table

1. ## Calculating totals in a table

Hello,

I have a table ranging from B9 to I9 downwards several thousand rows long, with the number of rows changing each day.

I have filters in my headers in order to filter and extract detailed information from the table.

I want to somehow calculate the sum for column G9down and H9down, these sums should ignore the results from rows which have been filtered out, and be displayed on, lets say, cells k6 and K7.

2. ## Re: Calculating totals in a table

Use SUBTOTAL function

I.E. =SUBTOTAL(109, G9:G10000)

where 109 is for filtered SUM.

3. ## Re: Calculating totals in a table

What do you mean by filtered sum?

4. ## Re: Calculating totals in a table

The function numbers for the subtotal function are:
Function_num(includes hidden values) Function_num(ignores hidden values) Function
1 101 AVERAGE
2 102 COUNT
3 103 COUNTA
4 104 MAX
5 105 MIN
6 106 PRODUCT
7 107 STDEV
8 108 STDEVP
9 109 SUM
10 110 VAR
11 111 VARP
Where 109 would be a sum ignoring hidden values

5. ## Re: Calculating totals in a table

Originally Posted by jsuarez199
What do you mean by filtered sum?
When you filter your table this formula will show you sum of viewable cells (while SUM(G1:G10000) will give you total sum).

6. ## Re: Calculating totals in a table

Awesome thanks a lot zbor!!

There are currently 1 users browsing this thread. (0 members and 1 guests)