Good day everyone,
Yet again I have returned with an inquiry. I am trying to work on this sales file where I wanted to extract the daily sales.
Here's the screenshot:
(Screenshot below is just a part of a big raw file which contains over 6 months worth of sales data)
Now, I was able to count the number of days by manually typing Monday, Tuesday, Wednesday, Thursday, Friday, Saturday and Sunday beside column B however I just cannot figure out for the life of me how to VLOOKUP and return the sum of each day.
I tried performing SUMIF and SUMPRODUCT but to no avail. I initially thought of performing multiple VLOOKUP however it would always return the same line.
Would any of you possibly know how I can do a lookup in column B with criteria per se 'Monday' and what it would do is count the number of 'Mondays' in column B and return the sum of those Mondays which can be found in column D.
Yet again I have returned with an inquiry. I am trying to work on this sales file where I wanted to extract the daily sales.
Here's the screenshot:
(Screenshot below is just a part of a big raw file which contains over 6 months worth of sales data)
Now, I was able to count the number of days by manually typing Monday, Tuesday, Wednesday, Thursday, Friday, Saturday and Sunday beside column B however I just cannot figure out for the life of me how to VLOOKUP and return the sum of each day.
I tried performing SUMIF and SUMPRODUCT but to no avail. I initially thought of performing multiple VLOOKUP however it would always return the same line.
Would any of you possibly know how I can do a lookup in column B with criteria per se 'Monday' and what it would do is count the number of 'Mondays' in column B and return the sum of those Mondays which can be found in column D.