Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I enter a function that has more than 7 nested functions | Excel Worksheet Functions | |||
Rate Calculation | Excel Discussion (Misc queries) | |||
How to use RATE function? | Excel Discussion (Misc queries) | |||
RATE v. IRR: which to use? | Excel Worksheet Functions | |||
XNPV vs. NPV(quarterly) different results | Excel Worksheet Functions |