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:
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:
No comments:
Post a Comment