Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 20
Default How to calculate pass/fail percentages entered on a spreadsheet?

I am trying to set up a spreadsheet with driving test results including one
column to say pass one to say fail and calculate the percentage of each on a
monthly basis. I can enter the info but don't know how to calculate the
percentages
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default How to calculate pass/fail percentages entered on a spreadsheet?


Hi

I've just assumed the pass and fails are in Col A.


I then put this formula in B1 to Count the number of passes and divide
by the number of Pass or Fails

=SUMPRODUCT(--($A$1:$A$1000="*pass*"))/COUNTA(A:A)

Same formula to find Fails

=SUMPRODUCT(--($A$1:$A$1000="*fail*"))/COUNTA(A:A)

Then Format cells as %

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=568630

  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 35,218
Default How to calculate pass/fail percentages entered on a spreadsheet?

I don't think that wild cards will work like that.

But if Pass (or Fail) is the only word in the cell:
=SUMPRODUCT(--($A$1:$A$1000="fail"))/COUNTA(A:A)
will work ok.

And if pass and fail are included in longer strings:

=SUMPRODUCT(--ISNUMBER(SEARCH("fail",$A$1:$A$1000)))/COUNTA(A:A)

will look within each cell.

(Similar formulas for Pass.)



VBA Noob wrote:

Hi

I've just assumed the pass and fails are in Col A.

I then put this formula in B1 to Count the number of passes and divide
by the number of Pass or Fails

=SUMPRODUCT(--($A$1:$A$1000="*pass*"))/COUNTA(A:A)

Same formula to find Fails

=SUMPRODUCT(--($A$1:$A$1000="*fail*"))/COUNTA(A:A)

Then Format cells as %

VBA Noob

--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=568630


--

Dave Peterson
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
Formula for Returning values in another spreadsheet lrbest4x4xfar Excel Worksheet Functions 1 October 14th 05 02:52 PM
Some exported records do not show on spreadsheet vulcan88 Excel Worksheet Functions 0 March 30th 05 01:11 AM
How do you calculate number of workdays from dates entered? tfleck Excel Worksheet Functions 1 March 25th 05 10:17 PM
How do you calculate number of workdays from dates entered? [email protected] Excel Worksheet Functions 0 March 25th 05 08:55 PM
Employee schedule: I want it to calculate time entered such as 11. Atlanta Rudy Excel Discussion (Misc queries) 2 January 6th 05 06:19 AM


All times are GMT +1. The time now is 08:40 PM.

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"