I am looking for a formula that would calculate percentage of certain entry. Let's say in column B I have different entries Y or N. In column H I have records AA,BB,CC,DD There are let's say 30 rows 10 of them contain letters AA which can have in the same row in column B letter Y or N. I would like to calculate how many of BBs are in column H and what is percentage of Y in column B that correspond to BBs. I hope that i am clear with my problem.
Many thanks in advance A.
Bookmarks