Sep 03 2020 09:54 AM - edited Sep 03 2020 09:58 AM
I have a table with different type of values in columns, where the two first columns is a date and the day of the week, followed by several columns with different values (e.g. sales).
I'm trying to calculate averages based on a specific weekday in a specific date range. For instance; I want to see the average of all Thursday's values during the last 4 weeks, or, the average of the Sunday's values during last month.
I'm able to create one of the two, i.e. the date range averages, or the weekday averages, but not the two in combination.
Suggestions?
Sep 03 2020 11:18 AM
Sep 03 2020 11:55 AM
I only get DIVISION/0 when using this. I need to enter a starting date and end date as a condition. However, I can't get it to accept a cell reference that should be higher/lower that a date specified in a cell outside the table. It is not allowed to enter ">" together with a cell reference.
Sep 03 2020 01:31 PM
SolutionIt is not allowed to enter ">" together with a cell reference.
Sure it is allowed. Lookup the many tutorials on the web.
Use ">"&A2.
Sep 04 2020 01:52 AM
Sep 03 2020 01:31 PM
SolutionIt is not allowed to enter ">" together with a cell reference.
Sure it is allowed. Lookup the many tutorials on the web.
Use ">"&A2.