Sum by Month with different dates

[NicBKK]

Hello all,

I have a list of guests that come into my hotel periodically (different check-in and check-out dates)
I have created areas for each of their stays
I would need to be able to sum by month of their check-out date (I marked in GREEN in my sheet attached)

THANKS A LOT

[Pete_UK]

Use the following formulae in the cells stated:

Q16: =COUNTIFS(P$5:P$14,">="&N16,P$5:P$14,"<"&EOMONTH(N16,0))

R16: =SUMIFS(R$5:R$14,P$5:P$14,">="&N16,P$5:P$14,"<"&EOMONTH(N16,0))

Copy these down to row 27.

Then you can copy that block of green cells into the other block.

Hope this helps.

Pete

[NicBKK]

Thanks a lot Pete, that worked ��

[Pete_UK]

You're welcome - thanks for the rep.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

Pete