UsefulGyaan Has Posted the Following On 06-23-2013 07:40 PM:

Problem Statement: I have grade-wise student numbers in column C as given below. I have written a formula in cell [A2] that sums up the total number of students in each grade. Now I want to put a filter on grade, i.e. column A, and see the total number of students in that grade in […]

[url=http://usefulgyaan.wordpress.com/2013/06/23/did-you-know-excluding-hidden-cells-from-sum-and-other-formulas-subtotal/]Did You Know :: Excluding Hidden Cells from SUM (and other) Formulas