I am using a simple Numbers spreadsheet to track an expense that only comes up a few times per year. I want to be able to have Numbers automatically add the values that come from each year.
Column A Column B Column C Column D DATE AMOUNT 2015 $500 1/15/2015 $500 2016 $1000 1/15/2016 $500 6/15/2016 $500
In other columns, I would like Numbers to sum all Amounts from 2015. Then below that, sum all Amounts for 2016, etc.
I have tried playing around with
SUMIFS and cannot seem to get it right.