Excel Magic Trick 442: Summarize Monthly Sales With Daily Transactional Dates - 5 Methods

[HearIsRahul]

Sir you did too much great task for new student to lern excel Thank's Thank's Thank's

[ExcelIsFun]

@HearIsRahul , you are welocme!

[sharmilade]

Can i use sumproduct with excel table?



[ExcelIsFun]

Yes!

[thuynguyenable]

Dear ExcellsFun,

I try to watch this video but it says " An error occurred, please try again later". Does this video have technical problem?

Can you advise where I can watch it? Thanks.

[ExcelIsFun]

YouTube is not very good. You just have to try it later. Usually, it works within a few minutes if you try it later.

[LotfyKozman]

It will be very helpful. Thanks in advance.

In my big budget, I usually use the Data Solver very frequently, as a result of the recalculations, my new numbers comes with 15 decimal. Please tell me how to get rid of it.

[ExcelIsFun]

What position do you want to round to? If to the penny use the ROUND function with a 2 as second argument in the column to the right of the numbers, then Copy, Paste Special Values.

[LotfyKozman]

Great job. I agree with you that the Pivot is the easiest and fastest solution for summarizing such a data, but still there is a shortage when you use the grouping command-- as it cannot group data on a weekly basis for each month. Is there is a solution for that? Thanks.

[ExcelIsFun]

You can do weekly data in a Pivot Table. You have to Group by Days and say 7 days and give it a start and end date. You can also do it with formulas when you have the start and end date for each week.

[ExcelIsFun]

SUMIFS and SUMPRODUCT functions can be used also.

I'll make a video in the next week showing the three methods.