Count formula not count hidden cells in table

**tlacloche** · 11-06-2013, 08:53 AM

Hello,

I have a table which I often use the filter.
I have a COUNTIF formula

Formula:

Please Login or Register  to view this content.

counting the amount of time a specific word is listed in the table. Lets say theres currently 5 "Apples" listed so my COUNTIF formula displays 5.

i want the COUNTIF formula to work based on how many are displayed. so if i use the filter and only 2 "Apples" are on display, I would like my COUNTIF formula to show 2.

Thanks

**XOR LX** · 11-06-2013, 09:11 AM

Hi,

=SUMPRODUCT((SUBTOTAL(3,OFFSET($E$2,ROW(E2:E17)-MIN(ROW(E2:E17)),,,))*(E2:E17="Apple")))

Regards

**tlacloche** · 11-06-2013, 02:15 PM

works great. thank you

**XOR LX** · 11-06-2013, 02:35 PM

You're welcome.

Count formula not count hidden cells in table

LinkBack

Thread Tools

Rate This Thread

Display

Count formula not count hidden cells in table

Re: Count formula not count hidden cells in table

Re: Count formula not count hidden cells in table

Re: Count formula not count hidden cells in table

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Formula needed to only count total cells entered and not count adjacent text entered cells

Count cells in table formula

Changing a Formula so it Won't Count Hidden Cells

Count the number of cell references to hidden and visible cells

Count with Hidden cells

Bookmarks

Bookmarks

Posting Permissions