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:
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:
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.
Then we will add the WEEKDAY Function in the SUMPRODUCT function.
The WEEKDAY Function requires serial number, return type (optional).
The serial number is the dates we have, so we will select the same which becomes B3:B10.
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)
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.
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.
By this, our overall formula becomes:
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).
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).
So, it’s easy, isn’t it?