Help with filters and counters

Hi team,

I know this is going to sound weird, but I'm going to use this example since the real data is private.

So I have this drop-down list of fruits, it's already set up in Column A, and right next to it, there's Column B which asks if it has been eaten yet. Now, what I'm trying to do is that in Column E only the eaten fruits show up, like filtered, and next to it, how many have been eaten.

If you guys could help me with it I'd really appreciate it, I know some advanced stuff, but this is like pro level to me.

Thanks in advanced!
validation data.PNG
sheet2.PNG

Here is a VBA alternative

Please Login or Register  to view this content.

How to install your new code

• Copy the Excel VBA code
• Select the workbook in which you want to store the Excel VBA code
• Press Alt+F11 to open the Visual Basic Editor
• Choose Insert > Module
• Edit > Paste the macro into the module that appeared
• Close the VBEditor
• Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

To run the Excel VBA code:

• Press Alt-F8 to open the macro list
• Select a macro in the list
• Click the Run button