Let’s say that the years are in `B97:B99`

. Then set `C97`

to

```
=SUMIFS(C$1:C$4, $B$1:$B$4, ">="&DATE($B97,1,1), $B$1:$B$4, "<"&DATE($B97+1,1,1))
```

… adjusting the `1`

and the `4`

to reflect the location of your data. This says add (sum) the values in column `C`

for the rows where the value in column `B`

is ≥ January 1 of the year indicated by the number in cell `B97`

but < January 1 of the subsequent year.
Then drag/fill down to row `99`

and out to as many columns as you need. Of course this can go into a separate worksheet; just use the `Sheet1!`

notation.

### Edit

If you wanted an average of these data, you could do

`=SUMIF(`

*args as above*`) / COUNTIF(`

*2nd through 5th args*`)`

If you want to handle the possibility that there are no data for a given year (so the COUNT would be zero, resulting in a division by zero error), do

`=IFERROR(`

*SUMIF/COUNTIF formula, from above*`,`

*value to display if error*`)`