Say I have column A for dates, column B for numerical values:
A | B
3/10 | 1
3/10 | 15
3/11 | 25
3/11 | 3
3/12 | 5
I want my chart to automatically update (when I create a new row) and use the sums values in column B per column A's unique dates.
eg:
3/10 -> 16
3/11 -> 28
3/12 -> 5
How would I go about doing this? I'm just so lost...
Bookmarks