Small VBA Macro: introduce cell text into a CountIF formular and get output
Hey Guys! I'm struggling with a problem and can't get over it.
I have a table that should only count if 2 values (Brand and Continent) are true in the same row and output the sum. (=COUNTIF(A2:A30;"SEAT";B2:B30;"Europe")
Now since that would mean I have to edit the formula every time I want to filter for a Brand (or later with more arguments), I would like to put it into a Macro (but didn't get it to work).
The goal is to only enter the name of the Brand somewhere in column E and it will automatically filter for it and give you the sum adjacent next to it (see picture).
Sorry for the inconvenience if this is a very basic problem. :-(
Reply With Quote
