Hi, everyone! I'm a newbie at Google Sheets and wondered if I could get some help on a...(formula? Data validation?) for a chart I'm working on.
What I'm looking to do is to make 2 drop down menus, then reflect the sum of those 2 values in a 3rd cell.
For example;
Box 1: January (which is the first month so it's value is 1) (But it would only show January in the list, not '1')
Box 2: March (which is the third month so it's value is 3) (But it would only show March in the list, not '3')
Sum: 4
So to the person using the sheet it looks like;
[January] [March] [4]
But naturally if they select different options, the sum would change.
[April] [December] [16]
I have the 2 dropdown menus, but I have no idea how to attach each option to a value...and even then, I have no clue how to reflect the sum of those values in the 3rd cell. Any help with this would be appreciated!
Bookmarks