#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10,593
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I enter a function that has more than 7 nested functions Tkokkine Excel Worksheet Functions 3 September 10th 06 02:26 PM
Rate Calculation zephyr Excel Discussion (Misc queries) 9 September 6th 06 05:02 PM
How to use RATE function? Eric Excel Discussion (Misc queries) 5 August 13th 06 04:30 PM
RATE v. IRR: which to use? [email protected] Excel Worksheet Functions 4 August 12th 06 09:09 PM
XNPV vs. NPV(quarterly) different results magis Excel Worksheet Functions 3 January 6th 06 06:21 PM


All times are GMT +1. The time now is 09:37 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"