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;
[ Ссылка ]
*** Online Excel Courses ***
Excel VBA for Beginners ► [ Ссылка ]
Advanced Excel Tricks ► [ Ссылка ]
Excel Formulas Made Easy ► [ Ссылка ]
The Ultimate Excel Course – Learn Everything ► [ Ссылка ]
Creating Sports League Tables and Tournaments in Excel ► [ Ссылка ]
Connect with us!
LinkedIn ► [ Ссылка ]
Instagram ► [ Ссылка ]
Twitter ► [ Ссылка ]
![](https://i.ytimg.com/vi/amJUtWBkAbs/maxresdefault.jpg)