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?
|