Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
psyd
 
Posts: n/a
Default Help with function


I am currently summing several cells on different sheets, determining a
percentage, assigning a 1 through 5 value based on the percentage, on a
seperate sheet I am taking the 1 through 5 values and trying to
determine a percentage for completed fields above 3 and the average of
these values.

I tried =average('sheet 1'$a$1,'sheet 2,etc.) but I'm having trouble
with this. I also need to take the percentage of those above 3 vs all
complete. Any help would be appreciated. :)


--
psyd
------------------------------------------------------------------------
psyd's Profile: http://www.excelforum.com/member.php...o&userid=16106
View this thread: http://www.excelforum.com/showthread...hreadid=275546

  #2   Report Post  
Alex Delamain
 
Posts: n/a
Default


I don't think you need the apostrophes
ie
=average(sheet1!A1, sheet2!A1,etc)

To get your percentage use something like
=if(a1<0.2,1,if(a1<0.4,2,if(a1<0.6,3,if(a1<0.8,4,5 ))))

Finally to get the percentage of cells with 3 or better

=countif(a1:a100,"=3")/count(a1:a100)


--
Alex Delamain
------------------------------------------------------------------------
Alex Delamain's Profile: http://www.excelforum.com/member.php...o&userid=11273
View this thread: http://www.excelforum.com/showthread...hreadid=275546

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
Averaging function Sarah Excel Discussion (Misc queries) 0 January 18th 05 05:09 PM
Function in XL or in VBA for XL that pulls numeric digits from a t Nate Oliver Excel Discussion (Misc queries) 0 December 14th 04 05:57 PM
I cant use englisch function names in a swedich version of excel PE Excel Discussion (Misc queries) 2 December 7th 04 02:00 AM
need to save values from a function before it changes Ron Excel Worksheet Functions 1 October 29th 04 06:29 AM
SUMIF(AND) FUNCTION Saariko Excel Worksheet Functions 9 October 28th 04 11:52 AM


All times are GMT +1. The time now is 04:31 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"