Hello clever people
I need help.
I need to count the unhidden rows that meet two criteria
In the very basic attachment I want to count the number of unhidden rows within A1 : B20 that have CHANGE and SOLO on the same row.
I know there will be some Sumproduct and Subtotal stuff going on but this is to much trail & error for me to put together.
Thanks in advance for your help
Bookmarks