Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculation w/ Filter
In my Excel sheet, i have the following formulas
calculated at the bottom of the data: Range("F" & NumRows + 2).Formula = "=COUNT(A7:A" & NumRows & ")" Range("J" & NumRows + 2).Formula = "=SUM(IF(FREQUENCY(A7:A" & NumRows & ",A7:A" & NumRows & ") 0,1))" This works fine, and it correctly calculates total rows and unique rows. The problem is when the user uses the filter function to filter out some of the data. When that happens, the total lines are not recalculated - but I want them to be. Any suggestions how to get the totals recalculated? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
DataFilterAuto Filter in excel 2007? | New Users to Excel | |||
Filter PivotTable dropdown items to match report filter | Excel Discussion (Misc queries) | |||
Excel auto filter doesn't recoginize case - won't filter AA from A | Excel Discussion (Misc queries) | |||
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions | |||
range.calculation with UDF not working when calculation is set to automatic | Excel Programming |