Sum Values by Weekday in Excel

3K views May 16, 2023

In this video we sum the values by weekday using a formula in Excel. The formula uses the WEEKDAY function to identify the day of the week of a specific date. This is the used in a condition to sum values. To do this with one Excel formula we used the SUMPRODUCT function. This can handle arrays. If we used SUMIF we would need 2 formulas because of the array of dates. The formula is then extended by using VLOOKUP and a helpful lookup table. A drop down list is created for simple weekday selection and then the formula runs. Find more great free tutorials at; https://www.computergaga.com *** Online Excel Courses *** Excel VBA for Beginners ► http://bit.ly/2JvnnRv Advanced Excel Tricks ► https://bit.ly/3CGCm3M Excel Formulas Made Easy ► http://bit.ly/2t3netw The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2viGg3J Connect with us!

#Computers & Electronics