I am trying to put a inventroy sheet togeather for the bar I work for. The computer will spit out reports of every item sold. I am trying to get excel to add them up and display them nice and simple. The probem is the reports only list what is sold so the items will not be on the same line every time.
What I am trying to do is have excel count the number in the cell NEXT to a cell with name x. For example:
A B
1 Bay Breeze 2
2 Quervo Tequilla 5
3 Captain Morgan 3
4 Margarita w/ quervo 3
5 Malibu 9
So what I want to see from the above info is:
Malibu 11 (bay breese + malibu)
Quervo 8 (quervo + margarita)
Captain 3
So next week if no bay breeze was sold and some martinis were sold the cells would be different
A B
1 Quervo Tequilla 5
2 Captain Morgan 3
3 Martini 5
4 Margarita w/ quervo 3
5 Malibu 9
So in one cell I can say look in a for the name Quervo or Magrarita or Margarita call Add all the numbers in cell B and show me them
Look the names Malibu or baybreese andshow me the total of the cells next (b) to the name.
If that makes any sence to anyone I could really use some help!
Thanks!
Ryan
Bookmarks