Home |
Search |
Today's Posts |
#1
|
|||
|
|||
countif across worksheets
I am trying to automate ta summary page of a quesionnaire process. The
questionnaire contains 6 worksheets. 5 of them are the questionnaires and the 6th is the summary sheet. On the questionnaires there are 3 columns: yes, no and n/a. On the summary sheet I need to count the values in the yes column and turn that into a percentage. The value placed in the field is an "X", and the top score would be 100% (5/5). At this point I am trying just to count the X's in the yes column. I am trying to use countif and listing the range as the cell in each worksheet, separated by a comma, then "X". It is not working and gives me an error - can't figure out why, nor how to fix it. Does anyone have any suggestions? Thanks in advance for your help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Countif multiple worksheets | Excel Worksheet Functions | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
Countif with multiple criteria and multiple worksheets | Excel Worksheet Functions | |||
"countif" from multiple worksheets within workbook | Excel Discussion (Misc queries) |