LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Formula conundrum calculating a percentage average...help!

I'm pretty new to anything more complicated than a simple formula, so please
bear with me.

Here's what I'm trying to do (unsuccessfully so far):

I have a cell, let's call it B11, that contains a numerical value (0,1,2, or
whatever).

In the column beneath the cell, I have a further 60 cells (say B7 to B66)
that will also contain a numerical value (0,1,2, or whatever).

At the bottom of that column, say in cell B70, I want to place a formula
that will calculate the percentage average of cells from the range B7 to B66
that exactly match the value in cell B11. (I.e., if 6 of those 60 cells had a
value that matched the value in cell B11, I should get 10% in B70, 12 out of
60 would give me 20%, etc.)

I haven't figured it out yet, so please help guys :)

TNX


 
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 calculating a rolling 12 month average in excel? Jeff Excel Discussion (Misc queries) 1 December 9th 05 09:11 PM
calculating a weighted average using formula bob green Excel Worksheet Functions 1 August 1st 05 10:33 PM
calculating a weighted average uisng formula bob green Excel Worksheet Functions 1 August 1st 05 06:31 AM
How do I average a formula without calculating zero values? KMHarpe Excel Discussion (Misc queries) 1 July 20th 05 06:05 PM
How do I create a formula to calculate the average percentage rat LD Excel Worksheet Functions 5 January 13th 05 06:17 PM


All times are GMT +1. The time now is 12:13 PM.

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

About Us

"It's about Microsoft Excel"