Response Count error

Hi experts

The attached spreadsheet contains a response total on sheet 'Chart' that is calculated from the row count of the 'Import' sheet not including the titles.  However, with the data included in the sample attached, there are 65 responses but it is only showing 34 on the 'Chart' worksheet cell 'I2'

Could someone help me correct this please?

Thaks
Andy
Survey-Reports-MASTER-v10.xlsm
JCIEAsked:
Who is Participating?
 
gowflowConnect With a Mentor Commented:
here it is, as if I read your intentions despite me saying the opposite I did it exactly as you wanted.

Regards
gowflow
Survey-Reports-MASTER-v10.xlsm
0
 
gowflowCommented:
in the sample attached, there are 65 responses

Where do you see that ? Do you count blank lines a response ?
gowflow
0
 
JCIEAuthor Commented:
Hi gowflow

Yes, I know there are 65 responses when you look at the import sheet and crosscheck the totals across the columns, but on the 'Charts' worksheet, it only shows response total of 34.

Andy
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
gowflowCommented:
In sheet Chart in Cell I2 it Is the number of Comments that you asked to be called Responses if you count them you have exactly 34.

I guess you want the number of Applicants who answered the test (could be that some may not necessarly had put comments) and these are 65

If you look at sheet Import 2 heading rows and total at row 68 this means
68-2-1 = 65

Shall we put in I3
Applicants 65

and in I2 we can change this to
Comments: 34

Pls advise
gowflow
0
 
JCIEAuthor Commented:
Hi gowflow

Aha, I see, apologies for the confusion.

Could we proceed as follows:
'Responses' in I2 and show the number of applicants
'Comments' in I3 and show the number of comments

Thanks
Andy
0
 
JCIEAuthor Commented:
Brilliant, yet again another great result.  Thanks again and apologies for the initial confusion.

Best wishes
Andy
0
 
gowflowCommented:
No problem. Tks and I posted a question on the intial question can you pls take a look ?
gowflow
0
 
JCIEAuthor Commented:
Hi

Is this the question, "Do you count blank lines a response ?" Are you talking about what we now know as 'comments'?  If so, the response can be calculated from the count of populated rows in the 'Import' sheet.  If not, can you explain further please?

Andy
0
 
gowflowCommented:
no I will put it here:

I see you have 2 accounts ?
andymacf
JCIE

will you be using both ? just for tracking purposes. I usually file all answers I give per the asker so I can follow at any time later and have the latest solution given.

If you will keep both no problem for me.
gowflow
0
 
JCIEAuthor Commented:
Ah, ok.  My boss agreed to purchase a business account as most of my posts are work related so all of my posts from now on will be from JCIE.  Having said that, I occasionally forget to login in with the correct account.

Thanks again
Andy
0
 
gowflowCommented:
no problem and your welcome.
gowflow
0
 
gowflowCommented:
I will keep this question monitored in case you need any help with any other question pls post a link in here.
gowflow
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.