I am preparing a count of items from Survey Monkey that may include the answer NA. I'll be counting the data from 40 questions. The other responses will include the numbers 1 - 6. I need the total count of the 1 - 6 excluding the NA. Thank you, in advance, for your help
Text value or error value?
The clients are completing a Survey and they choose the numeric value 1 through 6 to rate their response, but they are given the option of no opinion and enter the text value NA. Does that help?
If the responses are in column A enter the numbers from 1-6 and NA in column E. In column F enter and copy down.
Formula:
=COUNTIF(A:A,E1)
This will give a count of each 1 to 6 response.
In G1 enter
This will give the total number of responses that are 1 to 6Formula:=SUM(F1:F6)
If you simply want a count of the responses that are 1 to 6
Formula:=COUNT(A:A)
Text values will be ignored.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Thank you! While I was waiting I re-read the COUNT fx and realized it will automatically exclude a text entry. So, I've tested and am good to go! I very much appreciated the replies and they did help!
This is how it looked:
=COUNT(Sheet1!A2,Sheet1!D2,Sheet1!H2,Sheet1!K2,Sheet1!U2,Sheet1!W2,Sheet1!AE2,Sheet1!AG2,Sheet1!AP2,Sheet1!AQ2,Sheet1!AR2)
Thanks, Linda
Last edited by Linda Borza; 07-18-2013 at 05:19 PM.
Way to go! Thank you for the feedback.
You can also use a range in counting if there isn't other numeric values that you don't want to count:
Formula:=COUNT(Sheet1!A2:AR2)
If there is more than one row like this where there are 98 rows:
Formula:=COUNT(Sheet!1A2:AR100)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks