If you want to calculate the sum total of your earnings or expenditure or anything like that in reference to the weekday, here’s what you can do:

Example:

sum data by weekday

As you can see in the image above, we have taken date, weekday, amount earned in particular to the weekday. Now to calculate the sum total earnings that we have earned per weekday, this is what we will do:

sum data by weekday

We will use the SUMPRODUCT Function and after opening the same we will again open it; we are doing it to prevent any sort of errors.

Previously: Sum values between two dates quickly with SUMIFS Formula

=SUMPRODUCT((

sum data by weekday

Then we will add the WEEKDAY Function in the SUMPRODUCT function.

=WEEKDAY(

The WEEKDAY Function requires serial number, return type (optional).

sum data by weekday

The serial number is the dates we have, so we will select the same which becomes B3:B10.

sum data by weekday

Then we will come to the aspect of return type. In this, there are bunch of options given which have different kind of specifications. We will select the 2nd option as it satisfies our requirement.

(…)2 – Numbers 1 (Monday) through 7 (Sunday)

sum data by weekday

Then we will close the WEEKDAY Function and continue with the SUMPRODUCT Function array 1 only.

*Please note: we have not inserted a comma so we are still on array 1 and not array 2.

Then we will input the equal to sign and select the No. of Day.

sum data by weekday

Then we will close the bracket and as we used double openings in the beginning i.e. 2 brackets so we can do the same in the end of the formula as well. And so, here comes the next part of our formula.

We will multiply the amount with the formula we have entered up till now. And then we will close the bracket, i.e. final closing of the formula.

sum data by weekday

By this, our overall formula becomes:

=SUMPRODUCT((WEEKDAY(B3:B10,2)=I3)*D3:D10)

sum data by weekday

Now all we have to is press enter. And BAAAMMMM!!! The answer is 1190. This means that the total earning of Monday is 1190 (as per the data).

sum data by weekday

Now all we have to do is drag down the formula till Friday, or you can input the formula for every weekday (whichever is preferable).

sum data by weekday

So, it’s easy, isn’t it?