Sumif

[franklinsam]

I have an Excel table that is called Withdrawals, column1 is the date column and column2 is the amount. I'm trying to get a sum of column2 where the year in column1 is the current year. My formula looks like this
=SUMIF(YEAR(Withdraws[Date]),2023,Withdraws[Amount])

Excel is telling me that there is an error with the formula.

Any ideas why I'm getting this error?

 

[Fluff]

The range must be a range not an array. try using sumproduct instead

=sumproduct((YEAR(Withdraws[Date])=2023),Withdraws[Amount])

 

[franklinsam]

This works with 1 modification

=sumproduct(--(YEAR(Withdraws[Date])=2023),Withdraws[Amount])

 

[Fluff]

Glad to help & thanks for the feedback.