Hello to everyone,
I have an issue with an averageifs with weekday, month and year as conditions, and I am not able to make it work with the average(if())
I need to calculate the Avg. TOTAL_DELIVERY_TIME according to:
- weekday (TIME_ORDERED_UTC)
- month (TIME_ORDERED_UTC)
- year (TIME_ORDERED_UTC)
- TOT_DELIVERY_TIME <> ("null")
- TIME_ORDERED <> ("null") and <> 0
Can you help me? do you have suggestions
Thanks a lot!
Best,
Riccardo
Bookmarks