Forum Discussion
Adjust a formula to ignore hidden/filtered rows of data
I have a formula already setup to calculate the total occurrences of a unique ID in a column. =SUM(IF(ISNUMBER(A2:A2719)*COUNTIF(A2:A2719,A2:A2719)=1,1,0)) But when I have a filter set on a t...
kthersh I Solved a similar problem by adding a new column, named Show. And use of the Aggregate function. I Think that is the english name for it.
Agregate(3;1;[@Text]). Then the rows ahowing is 1. The hidden ones is 0.
I add a smal file as an excample. Which use the Filter function to show only rows ahowing in the original table.
/Geir