Excel Magic Trick 1453 Array Formula Count Customer Totals Between Upper Lower Limits, Each Month

Count Customer Totals Between Upper & Lower Limits For Each Month using an Excel Array Formula and the functions SUMPRODUCT and SUMIFS. Create a Cross Tabulated Frequency Distribution that shows a count of Customer Totals for each month and each Sales Category.

Related Videos:
Excel Magic Trick 1453 Array Formula Count Customer Totals Between Upper Lower Limits, Each Month
Excel Magic Trick 1454 DAX Measure Count Customer Totals Between Upper Lower Limits, Each Month

[johnborg]

Thanks Mike. It is always wonderful to have this FEAST of Array Formulas !! :) Thanks for your efforts so people like me will get to enjoy the power of excel.

[Al-Ahdal]

Another gem and jewel by Mike Girvin, awesome videos as always.

[Victor-ollo]

Array formulas = high level Thanks Mike.

[kjvstats]

Mike, another masterful video. FAA Operations and Nested Formulas all the way! I see you've moved on to DAX in a big way...simply the best. Thanks.

[Sal_A]

Very cool use of the formula. It might be unnoticed but the way your set up your model is what drives the formulas to do it's magic :)

[alexrosen]

Just wonderful! More of these please :-)

[MySpreadsheetLab]

Brilliant !! Perfect explanation !! Thanks Mike !! Why can't there be a default thumbs up button for ExcelIsFun ?

[rrrprogram]

Great video and Yaaa.... I am waiting for

[tejamarneni]

Hi Mike. I have been following your channel for awhile. You do a great job in making excel fun. Can you make the videos on MS Access too? I am learning a great deal from your videos.

[Theknurt]

How you made this complex excel is excellent.... even from Holland i love to look to you instruct

[douglaszulu]

Great video Mike... I would like to have a class with you for statistics and DAX, how can I do it?

[SteveCornelius]

Hi Mike: I discovered your channel a few months ago and have found your information very useful. I do have a quick pivot table question for you.

I created a data table in Excel 2016 and built a pivot table based upon the table name, not the range. When I add a new row to the data table, the pivot table does not recognize this additional data, even though when I click on the row, the data table name appears. I was hoping to be able to add new data and display it in the pivot table without having to redefine it. When I click on "Change Data Source, " the correct table name appears. Is there an additional step that I am missing or were my assumptions incorrect. Thanks!

[livinaskipp]

Would you need to change either the lower or higher limits by adding 1 to avoid counting possible doubles that may occur?
i.e from 1001 to 2000 and 2001 to 3000 instead of 1000 to 2000 and 2000 to 3000

[mansouribrahim]

what if some clients sales above 7000 ?