Excel Magic Trick 1065: SUMIFS: Month Over Month Sales Calculations From Transactional Data Set

See How to calculate Month Over Month Sales Calculations From Transactional Data Set using:
1. (00:40 min) Mouse Drag and Smart Tag to calculate the first of each month
2. (01:06 min) EDATE function to calculate the first of each month
3. (01:55 min) Custom Number Format to show serial Number Dates as Month Abbreviated Names
4. (02:49 min) EOMONTH to calculate the end of the month
5. (03:40 min) SUMIFS to calculate Month Sales
6. (06:00 min) Formula For Percentage Change
7. (06:28 min) Formula For Rate

[abigailcoy]

This has been the only video after watching a tonne that has actually helped me to do this!! Thank you so much for uploading this tip!

[excelisfun]

Excel Magic Trick 1065: SUMIFS: Month Over Month Sales Calculations From Transactional Data Set:

Cool Video with Many Useful Tricks:

[ajwatypingphotocopying]

boom I got buy one get one free offer from your video, I was looking for one solution but got an extra, thanks a lot and million like for your video.
you defined in very good way too :)

[davegoodo]

Thanks Mike! This video straightened me right out on this particular topic, thanks again!

[garyandrewranford]

Marvellous... Very well explained, unlike others. 5 stars

[ExploringExcelAmey]

Thanks for the Video Month over month sales calculation

[brianhale]

when i did my data on this, feb-dec worked perfectly. for some reason, for jan and only jan, it returned the entire data sum. all cells formatted exactly the same.

[ibrahimdaas]

Great video as always, you are truly a master ! What if we have the sales for multiple years, not only one year as in your example... how the formula would be ? the format cell fo E1 will be : mmm.yyyy ... then continue the data for many years ahead ...

[hafizirfanraza]

Thanks for such a amazing tips.
But I'm facing one problem. I want to to take data from 6 columns not only from two columns. Plz help me to solve this.

[westsidenad]

What if you want to calculate on specific product forexample you have 10 products and you want to calculate each product to get monthly sales.

[carloshallo]

Very helpful, but when I drag the SUMIFS formula downwise the ranges move by 1 aswell. What can I do? Thanks

[ozarishabh]

What to do if my Average range is lies between Multiple Column for example Starting from E2 to HD46

AVERAGEIFS(E2:HD46, E1:HD1, ">="&A10, E1:HD1, "<="&EOMONTH(A10, 0))

[gtizzle]

How can you do this with power pivot and a data model

[ErehwonsLost]

What happens if the date array doesn't contain a value - mine seems to error out.

[SHUBHAM-qemi]

I am just getting zeroes everywhere while applying this don't know why

[SteS]

If you're doing months could you not use =MONTH()