Another Excel question please

[Mike1983]

Hi all

I was wondering how to automate the following calculation...

What would I need to type in to cell C12 to count how many times "Dave" is mentioned in column A but only if there is a corresponding "Y" and then give it as a percentage based on the total times "Dave" is mentioned in Column A. I've manually typed in percentages to clarify my end goal when automated by formula.

Hope this is an easy one!

Thanks for your time

 

[Sui]

Something like this will work - =COUNTIFS(A2:A9,A12,C2:C9,"Y")/COUNTIF(A2:A9,A12) and just format the cells as a percentage.

Can be amended to work for whole columns etc.

 

[Mike1983]

Works perfect, thank you very much!