Google Form Summary of Responses

[Jarod M. Lambert]

I have a staff member that is using Google Forms to compile information. In a previous form, the summary of responses based the percentages on the number of responses to a particular question. So, the survey might have had 900 submissions, but only 400 hundred of them responded to a particular question. The percentages of responses to that question would be based on the 400 hundred. In the newer form, the summary of responses is calculated on the 900 form submissions regardless of whether they answered a particular question.

Has anyone seen this before or know how to force the summary of responses to calculate percentages based only on the responses to a question rather than the total number of form submissions?

Thanks,

--Jarod

__________________________________________________

Jarod M Lambert

Instructional Technology Coordinator

Technology, Conroe ISD

Tele: 936-709-7607 Cell: 936-672-1625

Email: jlam...@conroeisd.net

skype: jarod.lambert

[roni gold]

Hi Jarod,

I had to tackle a similar sounding question for a form of mine, and
with some help came up with the following solution.

Here are two formulas I use in one of my forms to count values within
a range which I think could address what you are looking for, if the
responses are of a numeric value. What you could do is have one cell
that counts the total responses, another cell that counts the
responses in a specific range, and then a third cell that finds the
percentage of responses based on the total count:

Formula1: =COUNT(filter(B1:B,B1:B>=0))
this formula finds the total count in column B of values that are
greater than 0 (it ignores blanks and only counts greater than or
equal to zero)

Formula2: =COUNT(filter(B1:B,B1:B<85, B1:B>65))
this formula finds the total count in column B of values that are
greater than 65 but less than 85

Formula3: =D2/C2*100
(I actually put a variation of this formula so the answer is rounded
to give me one decimal place by adding a rounding function to formula
3 like so:
=round(D2/C2*100, 1)

So for example what I would do is:
a) Put Formula1 in cell C2 so cell C2 show the total student
responses.
b) Put Formula2 in cell D2 so cell D2 shows the total student
responses that are between 65 and 85
c) Finally in cell E2 I put Formula3 that give me the percentage of
students in the class between 65 and 85
d) If I need to find students that scored say between 50 and 65, I
modify Formula2 to fit this different range and put it in cell F2 and
then in F3 I put Formula3 again except it says F2/C2*100
e) In Row 1 above C, D, E, and F I label each to make sure I know what
each value is



Let me know if this helps at all, I can also share the sheet with you
if you'd like just shoot me an email if that'd help. Feel free to get
back in touch if you have any further questions or if anything was
unclear.

Best, Roni

> Email: jlamb...@conroeisd.net
> skype: jarod.lambert