Sum by Year

[tlraymond0720]

I have a rather long schedule that I am preparing that details expected expenses by month...

I was trying to create a formula that would sum the expected expense total for each year

In Column A, I have the months, January-2010, and so on, some through 2022, and in Column F I have the expected Expense amounts.

I'd like to add totals at the bottom of each schedule that totals the expense by each year.
I was using the SUMIF, but I can't quite get the formula to evaluate correctly.

Any help would be greatly appreciate!

[royUK]

Are the dates entered as dates?

Maybe attach a workbook with some dummy data

[tlraymond0720]

So the attached file is a short sample of what I am working with...

I have dates in Column A that include year, and amounts in col F.

I want to put totals at the bottom of each page by year...

[tlraymond0720]

Any help would be greatly appreciated...

[royUK]

Why not reorganise your data into a better format? Then use a PivotTable

[tlraymond0720]

I realize this can be accomplished by using a pivot table, but i have about 40 worksheets all in similar fashion, and many have schedules out till 2022.

I already have several index columns, but thought a simple SUMIF formula might accomplish what I'm looking for. I guess I'm just not stacking the formulas correctly. I can figure another way around it, but that would take longer.

Thanks anyway.

[WHER]

A helper column would make the use of SUMIF possible.