SumIf


show more SumIf provides you with in-depth training on Business. Taught by Lorna Daly as part of the Excel 2007 Essential Training show less
please wait ...

SumIf

The owners of EatCake have just finished their year-end Inventory, and had everyone put their accounts into a spreadsheet, however, no one did a tally of each Item Type. So now they either print off the pages in the worksheet and count them by hand or they use one of the advanced functions Excel offers to do the work for them. This movie's going to cover a lot of the concepts we've reviewed so far, so you may want to watch it a few times. Open EatCake 18 to follow along. We're going to add up the inventory items for three areas: Pastry, Buttercream and Sugar Free.

And you'll see that we already have an example here in our Pastry area, it's saying that there are 7 current inventory items under the Pastry item type. Let's just see if that's right. I've got 2 here under Pastry, and if I scroll through the visible area, I see another Pastry with the inventory of 5. The total of those two is 7, so I know in my formula is calculating correctly. Now, let's just t...

SumIf
Video duration: 4m 23s 5h 13m Beginner

Viewers:

SumIf provides you with in-depth training on Business. Taught by Lorna Daly as part of the Excel 2007 Essential Training

Subject:
Business
Software:
Excel
Author:
please wait ...