Hello, Please can I have some [more] assistance with a couple of formulae? I'm nearly finished now so will slow down on the posts!
So, in column Q I have data that says whether or not a target has been hit in the form of either "Yes", "No" or blank if certain criteria are met.
I need to write two formulae......the first one needs to show the number of "Yes" as a proportion of all nonblank entries in column Q, but only if Column I equals "Factory Quality".
The second needs to show the same as above, but with the additional condition that B must equal "11"
Can anyone advise, please?
Thank you
Bookmarks