Geek Answers Handbook

Change Excel Formula to Sum Only Visible Cells

I use the following formula to create a total number of unique values

= SUM (IF (FREQUENCY (SEARCH (C4: C9, C4: C9.0), SEARCH (C4: C9, C4: C9.0))> 0.1))

However, now I use an autofilter, so now I need to sum it up only the visible lines. I read that I need to use SUBTOTAL instead of SUM, but I'm not sure how to change the formula above correctly.

Any ideas?

+5
source share
1 answer

=SUBTOTAL(9,C4:C9), 9 - sum ( , intellisense, , ).

, 2003 , , 2007 , , ( ) Data .a >

: , COUNTIF : =COUNTIF(C4:C9,"=FREQUENCY(etc.)>0"). , MATCH.

+3

More articles:


All Articles