Tag: SUMIFS Function

Excel Magic Trick 1394: Excel Formulas for: % Column Total, % Parent Total, % Parent Row Total

Welcome to Excel Magic Trick number 1394. If you want to download this Excel workbook, Excel Magic Trick 1393-94 so you could follow along, click on the link below the video. Wow, we have a crazy video here. We’ve got to calculate formulas for traditional pivot table calculations, such as percentage of column total, percent…

Read MoreView 14 Comments

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 1417 Excel Functions Ranking Unit & Total Profit for Products within Manufacturer

Welcome to Excel Magic Trick number 1,417. Hey, if you want to download this Excel workbook file so you can follow along, click on the link below the video. Hey, in this video, we’re going to talk about ranking. Now we’re going to do it for unit profit and total profit. Not only that, but…

Read MoreComment

Excel Magic Trick 1405: Monthly Totals Report: Sales from Daily Records, Costs from Monthly Records

Welcome to Excel Magic Trick number 1,405. Hey, if you want to download this Excel workbook so you can follow along, click on the link below the video. Hey, we got to see how to use sumif to calculate monthly revenue from daily sales and then monthly ad costs from monthly amounts. Now, here’s our…

Read MoreView 20 Comments

Running Total in Column, Power Query, DAX or Worksheet Formula? Excel Magic Trick 1553

[MUSIC PLAYING] Welcome to Excel Magic Trick number 1,553. Hey, in this video, we’ve got to talk about how to create a running total in a column. And we want to see how to do it with a worksheet formula, Power Query M Code, and a DAX formula. Now, this question comes from Geert at…

Read MoreView 48 Comments