Audit Tool Question
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. |
Audit Tool Question
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 |
All times are GMT +1. The time now is 11:55 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com