I want to count how many rows contain the name of a certain accountant in column A where column B contains Level 1 or Level 2 or Level 3 but not Level 6.
I could get it done with a long drawn out sumproduct but surely there is a better way.
I could get it done with a long drawn out sumproduct but surely there is a better way.