An Excel Stocktaking Formula Required

  • Thread starter Thread starter blank
  • Start date Start date
B

blank

Hi folks, Heres the problem; hope someone can help me with the
solution.

1 When stocktaking in our avocado nursery there are 3 variables:
Location, Type, Quantity
2 There are about 100 Locations and 75 Types
2 For each Location we list the Types and Quantities
3 Each Location contains multiple Types and Quantities
4 Identical Types recur at multiple Locations (that's the akward bit)

What we need is an Excel formula that will allow us to have a clerk key in
the Types and Quantities to create a summary. I see this as simply two
columns: Column A = Type, Column B = Quantity. (The location is irrelevant
to the summary, which is just a list of total Quantity of each Type.) The
clerk would use the stocktake sheets to enter the codes for each type and
the quantity. The formula would then magically combine the multiple
occurances of each of the Types and add their Quantities to provide a
summary.

So the question is: what is the formula used to allow this to happen? If
it can be done I might have a life again at the end of each month. That
would be nice.
 
What are you trying to do, count the quantities?

If so, assuming Type in column B, quantity in column C, then in some other
column, say H type the type, and add this formula to I

=SUMIF(B:B,H1,C:C)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top