0

I have a workbook for tracking my inventory in real time.

I want to have my inventory crew count and add the data in line along with the receiving and departing shipments of 12oz bottles. For instance, when we Start the week with 343,520 bottles. This number is totaled out and placed in J5. The next day we check the count and enter in 343,520 and is placed in J6. The totals of the rows pallet and layer count are sumed for each row (or action) and placed in the L column.

To get the current total on hand, A2 sums L5:L47. However, I do not want the total to reflect as 687,040. Instead I want the equation to reference Column A and see that A6 says 'Inventory' or 'Inventory Count' and know to skil J6 when A2 (Total Bottles on hand) is summing L5:L47.

enter image description here larger view

6
  • Thanks for the edit @birdman3131, when I had tried putting the image inline like that, it said I needed more reputation before doing that. :) Mar 17, 2015 at 18:37
  • Not sure if i understand your need exactly, but a combination of SUMIF should enable you to do the trick. SUM cell in column L IF cell in column A does not say "Inventory..." and (or plus) SUM cell in column J IF it does. Mar 17, 2015 at 18:43
  • Thanks for mentioning the SUMIF function. I screwed around with it and got this to work just as I needed it! Thanks, and I hope this helps someone else too. =SUMIF(Table1014152427[Action],"<>Inventory Count",Table1014152427[Unit Total]) Mar 17, 2015 at 18:53
  • You're welcome, looked like all you needed was a hint. ;-) Mar 17, 2015 at 18:57
  • @AndrewMcAtee: "bare with me"? I'll read your question, but I'm not taking MY clothes off. :-)
    – fixer1234
    Mar 17, 2015 at 19:23

2 Answers 2

1

You can use the SUMIF function for this. You'll want something like:

=SUMIF(A5:A47, "<>Inventory*", L5:L47)
0

@TheUser1024 mentioned the SUMIF function and I was able to get this to work. Hope this helps someone with a similar question!

=SUMIF(Table1014152427[Action],"<>Inventory Count",Table1014152427[Unit Total])

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .