# 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.

Thanks in advance   Register To Reply

2. ## Re: Calculating totals in a table

Use SUBTOTAL function

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

where 109 is for filtered SUM.  Register To Reply

3. ## Re: Calculating totals in a table

What do you mean by filtered sum?  Register To Reply

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  Register To Reply

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).  Register To Reply

6. ## Re: Calculating totals in a table

Awesome thanks a lot zbor!!  Register To Reply

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