Hello all,
I am working on an analysis of our membership base and was wondering if I could automate some functions. Please see attachment.
In this example I have added numbers in column A which represent in this case the membership types we have and in column b it represents what their membership status is.
The data in column F until K would represent a table where I want to show how many members have a certain membership status (sorry English is not my first language so I am explaining as good as I can).
So I want to count in Cell G3 how many Number 1 members are active, in H3 how many Number 1 members are due for Renewal etc. I was thinking of a combination with SUMPRODUCT, and IF and maybe VLOOKUP or something like that, but I am not entirely sure how to formulate it.
Thanks!
Bookmarks