Strike Rate %

G

geordie

I have a spreadsheet which shows a list of projects, what I want to do is to
be able to show from the number of hits for each projet show the Strike Rate
percentage i.e. if I have a project which has 20 items in it and of these 8
have figures and 12 do not how can I show this?
 
B

Bob Phillips

=SUMPRODUCT(--(A2:A20="Project
1"),--(ISNUMBER(B2:B20)))/COUNTIF(A2:A20,"Project 1")

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top