Tag: FREQUENCY Array Function

Excel Magic Trick 1378: Average of Customer Total Sales by Product: Formulas, DAX or Array Formula?

Welcome to Excel Magic Trick number 1,378. Hey, if you want to download this Excel workbook– Excel Magic Trick 1,378 Start– or the finished file so you can follow along, click on the link below the video. Hey, we’ve got a great video here. We’ve got to calculate the average of customer total sales by…

Read MoreComment

Excel Magic Trick 1397: Excel Count Formulas for Running Total and % of Running Total & Ogive Chart

Welcome to Excel Magic Trick number 1,397. Hey, if you want to download this Excel workbook, Excel Magic Trick 1,396 to 1,397 so you can follow along, click on the link below the video. Hey, in this video we got to talk more about running total calculation and percent of running total calculation, and the…

Read MoreView 12 Comments