Friday, October 5, 2012

yogi_Compute Frequency Of Data In Sheet1 Q6 to Q65 For Classes in Range B2 to B6

Yogi Anand, D.Eng, P.E.      Google Spreadsheet   Post  #791  Oct 05, 2012    www.energyefficientbuild.com.

user IrishSaints said: (http://productforums.google.com/forum/?zx=5oxmlt3amxrw#!mydiscussions/docs/rsAL3qsPBt0)
Attempting to use the Frequency function between two sheets?
Hello everyone,
I am using Google Spreadsheets on a PC in Windows 7.
I am attempting to get the FREQUENCY function to work properly between two separate sheets within the same spreadsheet file. On my second sheet I have labels for grades in cells A2-A7 (F, D, C, B, A, A+), a corresponding range for the scores to the grades in cells B2-B7 (49, 59, 69, 79, 89, blank), and in the C column I am trying to develop a formula which brings in a range of scores from cells Q6-Q65 (first Sheet) and calculate the frequency of how many scores fit into the ranges from B2-B7 (sheet2). 
I cant seem to figure out the formula to accomplish this. Anyone I have asked before posting this has told me I can accomplish this by using the FREQUENCY function but has not said how.
Any Help would be greatly appreciated. Thank you in advance.

--------------------------------------------------------------------------------------
following is a solution to the problem: