I am trying to tally a column by month

Jen1236

=SUMIF([End Date]:[End Date], MONTH(@cell) = 4, Pricing:Pricing)

Trying to tally my pricing column if the 'end date' column is within the month of April.

I am getting "INVALID DATA TYPE"

@Paul Newcome - I have found your answers to other helpful in the past

Jen1236

I figured it out for anyone who might need it in the future

=SUMIFS(Pricing:Pricing, [End Date]:[End Date], AND(IFERROR(MONTH(@cell), 0) = 4, IFERROR(YEAR(@cell), 0) = 2022))

Genevieve P.

Thanks for posting your solution! 🙂