in most of the cases the data is in the same location on both sheets. There are about 15 data columns on each sheet and 3 categorization columns (data1 data2 ..... data15 category1 category2 category3). names of the sheets are survey1 and survey2 . there are multiple sheets in the workbook but only 2 data worksheets
If there are only 2 sheets then the easiest way would be like this...
With the data located in the same range on each sheet, A2:B5...
On some other sheet:
A1 = Yes
A2 = No
Enter this formula in B1 and copy down to B2:
=(SUMIF(Survey1!B$2:B$5,A1,Survey1!A$2:A$5)+SUMIF(Survey2!B$2:B$5,A1,Survey2!A$2:A$5))/(COUNTIF(Survey1!B$2:B$5,A1)+COUNTIF(Survey2!B$2:B$5,A1))
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks