How to create a chart in Google Sheets for yearly value growth when the data is separated by quarters?
Enter these formula in cell D1 and E1 and copy down for as many years data exists.
Both formula rely on the
OFFSETreturns a range reference
ROWSreturns the number of rows in an range.
The Year value looks at Column A; it returns a single cell, every 4th entry, and
MID extracts the year name.
The Annual value looks at Column B; it returns a range of four cells, and adds those values.