Hello!
I am trying to sum revenue values by "class" (Cabin,Tent or RV) depending if it is a weekday or weekend. It also needs to be by month. Fridays are considered weekends. I got as far as summing by weekday function, but could not get it to sum by month.
Tent rentals by weekend for January, Feb, March, Etc.
Tent rentals by weekday for January, Feb, March, etc.
I'd also like to average the occupancy by weekend by month.
Same for weekdays.
I don't see where you have mocked up expected results.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Hello. Thanks for looking at this.
In the first 18 rows or so I have the months trailing to the right with the ALL TIME in column F November of 2022 in Column H, October 2022, Column I, so on. (i'll eventually move it to a DASHBOARD tab, but left on same tab for simplicity). In columns AR-AZ I have the Occupancy and revenue by class (well actually only for Class A as that's were I got stuck, but will add revenue for classes R and T. The days moving down in those columns are conditionally formatted to show weekends (but only Sat and Sun.. I've decided to add Friday to the weekend totals as well)
Not sure you understood my question: I am looking for the RESULTS you want. Where have you manually mocked these up?
I haven't and didn't think to do so. Sorry for inconveniencing you. I have been working on it since uploading so I'll need to take thread down, mock up desired RESULTS and re-upload.
No - all you need to do is add a new workbook to your next post to THIS thread with the expected results added. No need for a new thread (you are not allowed duplicate threads here).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks