Hi there.
I have probably made no sense at all
..... i will try to explain further
- i have 2 teams with different members (columns A & B)
- i have a list of questions (column c)
- In Column 'D' I want to add a data validation pull down list to select the names from team A or B (between a2:b8) - im not sure how to add a list across 2 columns, i only know how to add it in 1 column
- once the name is populated in column D, i need to have row 12 accumulate a score based on what team they are on
- team member on team#1 is selected in the pull down, team#1 total gets a point (row 13)
- as additional questions are answered, i need the totals to accumulate
today team #1 has a 5 & team 2 has 2 but next week team 2 can answer 2 additional questions, i want the total to change to 4 etc....
please help & as usual thanks so much !!!
I have probably made no sense at all

- i have 2 teams with different members (columns A & B)
- i have a list of questions (column c)
- In Column 'D' I want to add a data validation pull down list to select the names from team A or B (between a2:b8) - im not sure how to add a list across 2 columns, i only know how to add it in 1 column
- once the name is populated in column D, i need to have row 12 accumulate a score based on what team they are on
- team member on team#1 is selected in the pull down, team#1 total gets a point (row 13)
- as additional questions are answered, i need the totals to accumulate
today team #1 has a 5 & team 2 has 2 but next week team 2 can answer 2 additional questions, i want the total to change to 4 etc....
please help & as usual thanks so much !!!