Can someone show me how to write this formula so that it looks at a specific year to obtain a total?
=SUMPRODUCT(C$7:C$200,--(TEXT(A$7:A$200,"MMM")=A$207)) *A207 contains the formula =TEXT(TODAY(),"mmm")

The formula shown does provide the information needed for the current year, however I have the spread sheet set up with multiple year columns. Each separate years column will have the dates for that particular years expenses.

The formula shown needs to provide the current month data only for the current year. Currently every entry in 2022 should show in the total column cell for 2022 , and not show entry's that have a year of 2023 for example.

I have copies of all columns moving left to right for year 2022's thru 2030 and I need the totals to only show for the year and column the data is recorded. I can't simply use the NOW() or (TODAY() function as it will change the totals in every year's column to the current year as the years go by.

Thanks for any help offered!
Fred