This page will describe the simple and useful formulas to sum the values from a range by weekday in Excel Office 365. Let’s see them below!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel
General Formula:
- To sum the values by weekday in Excel, use the below formula.
=SUMPRODUCT((WEEKDAY(dates)=day_num)*values)
Syntax Explanations:
- SUMPRODUCT – The SUMPRODUCT function multiplies the corresponding arrays or ranges and returns the sum of the products.
- WEEKDAY – In Excel, this function returns a number (ranging from 1 to 7) that represents the day of the week for a given date. Read more on the WEEKDAY function.
- Date – It represents the input dates that are given in the worksheet.
- Values – It is the input values.
- Multiplication (*) – In this symbol will multiply any two values or numbers.
- Comma symbol (,) – It is a separator which helps to separate a list of values.
- Parenthesis () – The main purpose of this symbol is to group the elements.
Example:
- Let’s consider the below example, to sum the values by weekday.
- First, we will give the input values in Column C and Column D.
- Then, enter the given formula in the formula bar section.
- After applying the formula, it displays the result in Cell H3.
Wind-Up:
From this tutorial, we explained the formulas to sum the values by weekday in Excel Office 365. Hope you like this article. If you feel this article is useful to you, then leave it in the below comment section and don’t forget to share your worthwhile feedback. Thank you so much for Reading!! Keep learning on Geek Excel!! *and Excel Formulas *!!
Top comments (0)