Sum values of one column, so long as the date in another column is between a range

[RobList]

Hi,
I promised I have tried to do this myself, without success!!
I run a little airbnb business. I keep a simple spreadsheet of when the customer checks in and how much their booking is worth.
I want to do a simple tally so I can see at a glance how much revenue I'm making each month.
The check in date is in Column C, and the value of their booking is in column M. So for Feb I'm doing:
=SUMIFS(M2:M50,C2:C50,”>=2/1/2023”,$M$2:$M$50,”<=28/02/2022”)
(have tried DD/MM/YYYY formats too).

Can anyone help, I'd be very grateful!

Cheers
Rob

 

[Fluff]

Hi & welcome to MrExcel.
Shouldn't it be

=SUMIFS(M2:M50,C2:C50,">=2/1/2023",C2:C50,"<=28/02/2023")

 

[RobList]

I've fixed it!!!
=SUMIFS($M$2:$M$50, $C$2:$C$50,">=2/1/2023", $C$2:$C$50,"<=2/28/2023")

 

[RobList]

Hi & welcome to MrExcel.
Shouldn't it be

=SUMIFS(M2:M50,C2:C50,">=2/1/2023",C2:C50,"<=28/02/2023")

Thank you buddy!!!

 

[Fluff]

You're welcome & thanks for the feedback.