You are reading a single comment by @Dooks-Fatberg and its replies.
Click here to read the full conversation.
-
And like that meaning is returned to @Chalfie 's life!
-
Use the subtotal function http://www.extendoffice.com/documents/excel/1286-excel-sum-filtered-rows.html#a1
-
Use a pivottable?
If you want to use the results in a formula, see GETPIVOTDATANote that I haven't used Excel in anger in over 4 years and my life is definitely no worse.
Sam_w
rhowe
@Dooks-Fatberg
How does one, in Excel 2010, set it up so that hidden or filtered out cells are excluded from sum formulas?