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
Use SUBTOTAL function
I.E. =SUBTOTAL(109, G9:G10000)
where 109 is for filtered SUM.
What do you mean by filtered sum?
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
Last edited by ragulduy; 06-04-2013 at 08:36 AM.
When you filter your table this formula will show you sum of viewable cells (while SUM(G1:G10000) will give you total sum).Originally Posted by jsuarez199
Awesome thanks a lot zbor!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks