PDA

View Full Version : Did You Know :: Excluding Hidden Cells from SUM (and other) Formulas - SUBTOTAL



Transformer
06-23-2013, 07:21 PM
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 […]http://stats.wordpress.com/b.gif?host=usefulgyaan.wordpress.com&blog=50473542 &post=1088&subd=usefulgyaan&ref=&feed=1

[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