Hi,
many thanks for the help! That code of yours might prove useful going forward - hidden cells are not so uncommon.
In this case, however, they are only filtered for reasons I know now - and further down, there are more lines which are filtered. By use of another formula inbetween and a COUNTIFS, it works fine now.
It's probably not the most elegant or slimmest possible routine, but it works, that is the target.
Best regards,
Officer_Bierschnitt
Last edited by Officer_Bierschnitt; 10-30-2015 at 05:08 AM.
Reason: additional info
|