Audit Tool Question

  • Thread starter Thread starter WesS
  • Start date Start date
W

WesS

I have an audit tool that has 4 check boxes basically with 72 questions I
would like to be able to click once in a cell and get a check mark or an X
and then get the spreadsheet to tally the number of checks or X's in each
column any help would be appreciated.
 
An easy solution would be to type an "x" into the cells of your choice (you
could also use Validation, select the cell(s) you want the user to be able to
select "x" or no "x" then go to Data --> Validation, under "Settings" tab,
choose "List" under the Allow: criterial; for the source, type "x,o" (without
the quotation marks), then press "OK." Validation allows the user to only
choose between those options that you listed through the use of a pull-down
menu.). To count the number of X's in a column use the formula:

=COUNTIF(A1:A4,"x")

Where A1:A4 is your range and your criteria "x." It will only tally a cell
if it contains x. You will probably have to change the range to suit your
needs.

Enjoy and I hope this helps, Jim
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Please help 5
if, else questions 1
Building closed workbook file path within an Index Function 6
Formula Auditing 3
Need help creating a formula that will auto post amts when marked. 1
Allen Brown's audit log code "insert" problem 0
Stumped on a continuous form 9
Word Using the 'IF' Formula in MS Word 2010 0

Back
Top