Could someone help me with this sheet summary formula?

AnaGB

I'm trying to create a formula that adds the amount in the "Amount" column only if the "Revenue Period" column contains "2024". When using this formula I get "0"..

=SUMIFS("Amount", "Revenue Period", "*2024*")

heyjay

=SUMIFS(
[Amount]:[Amount], 
[Revenue Period]:[Revenue Period], IFERROR(YEAR(@cell), 0) = 2024)
)

Paul Newcome

Assuming [Revenue Period] is a date type column housing date values, you would use something more like this:

=SUMIFS(Amount:Amount, [Revenue Period]:[Revenue Period], IFERROR(YEAR(@cell), 0) = 2024)