Headline31
New Member
- Joined
- Nov 30, 2017
- Messages
- 13
I have a table that has a monthly drop down list and a team list. I have been able to figure out how to make the data change based on those 2 factors using an IF(AND) formula, however I am needing the data to locate to a different cell (XXXXXXX) as well but NOT change. Is it possible to take the sum of January/Team X and move it to the second table and not have it change based on the first table?
<tbody>
</tbody>
January (drop down) | Team X (drop down) | SUM | Team X | Team Y | ||
20 | January | XXXXXXX (20) | ||||
a | 1 | February | ||||
b | 5 | |||||
c | 7 | |||||
d | 4 | |||||
e | 3 |
<tbody>
</tbody>