Strike Rate %
 

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?

Strike Rate %
 

=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)

"geordie" wrote in message
...
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?