It is always better to use SUBTOTAL formula instead of SUM. SUBTOTAL returns the sum of a list or database that are visible and ignores the number hidden. This is especially useful when filter option is used and when we are looking at sum of those filtered. Here is how it works: 1. First picture shows the filter used. and the subtotal formula used wherein, the total that will be displayed is 300 and does not include the hidden cell. 2. SUBTOTAL not only gives SUM of the visible cells, but you can also compute Average, Count, Max, Min etc. The list is shown in the 2nd picture. 3. The formula in the first picture says SUBTOTAL(9,c2:C4) where 9 indicates SUM which is there in the 2nd picture and C2:C4 is the range to compute the sum I shall get back to you tomorrow with another interesting feature.. Wait for it!!
Posted on: Thu, 31 Jul 2014 09:53:53 +0000
Trending Topics
Recently Viewed Topics
© 2015