sum up totals in lookup table

**rookie37** · 07-28-2014, 10:16 PM

Many thanks to those that helped on my lookup question. I feel silly as it was an obvious mistake.

I need to make a program to take inventory at a bakery. We do this twice a day. Our products are loaves of bread. We have white, multigrain, soy and lindseed, low gi, and gluten free.

They are in pallets, trolleys, crates, boxes, pallet rows (part of a pallet) and individual loaves (singles)

I need to find out how many loaves that we have. How do I total them up?

unpack2.xlsx

**alansidman** · 07-28-2014, 10:21 PM

In E17, =SUMIF($B$5:$B$14,C17,$E$5:$E$14) and copy down.

**ajryan88** · 07-28-2014, 10:22 PM

Hi,

In the first green cell on Sheet1 (E17), enter this formula:

Formula:

=SUMIF($B$5:$B$14,$C17,$E$5:$E$14)

Then fill this formula down as far as you need to.

If you are using a version of Excel prior to 2007 (which I assume you aren't, as your workbook is in the .xlsx format introduced in Excel 2007), then you will need to use the following array formula instead, as SUMIF isn't recognised:

Formula: