excel_noob_
New Member
- Joined
- Mar 21, 2020
- Messages
- 2
- Office Version
- 2016
Hey everyone,
My question is the following:
I have a schedule for a set of connections A-C provided to you as per below screenshot and I would need to know is how often each connection is served in a respective calender month.
In case the “Day of Week” column entries aren’t self explanatory: for example - connection A is only served on the weekdays Mondays, Tuesdays, Saturdays & Sundays.
I am certain that the sumproduct function can be used to solve this problem – and by means of using workarounds I was already able to find out how to count the total number of frequencies in the timeframe. Unfortunately, I can’t figure out the missing AND criterion that would allow me to distinguish the number of frequencies per calendar month. Do you guys have a solution for this one?
Sincerely,
Finn
My question is the following:
I have a schedule for a set of connections A-C provided to you as per below screenshot and I would need to know is how often each connection is served in a respective calender month.
In case the “Day of Week” column entries aren’t self explanatory: for example - connection A is only served on the weekdays Mondays, Tuesdays, Saturdays & Sundays.
I am certain that the sumproduct function can be used to solve this problem – and by means of using workarounds I was already able to find out how to count the total number of frequencies in the timeframe. Unfortunately, I can’t figure out the missing AND criterion that would allow me to distinguish the number of frequencies per calendar month. Do you guys have a solution for this one?
Sincerely,
Finn