PLEASE Help

[Guest]

I have a spread sheet which I keep a record of all my sowing (plants)
I want to keep an automatic seed stock count by varity how can I do this.
On my sheet i have
Batch No, Varity, Qty, Customer, Date Sown, Delivery Date,
12345 Bastile 100, van Dyke 12/12 25/02/06

What I want to do is every time I sow Bastile it automaticly takes the
amount off my stock on another sheet .We sow 25 varitys a day so can not
use cell No's must use names but how does excel do this as each name will not
apper in a set cel.
Help please thank you

 

[Guest]

Try approaching this with SUMIF. You can read about it's usage in Excel
help. You would need to change the qty for Bastile in your example below to
a negative number. The basic idea would be to subtract what you have used
with the SUMIF function.

Let me know if you have questions.

 

[Roger Govier]

Hi

On Sheet2 have your Varieties and Opening Stock listed, but add 2 new
columns headed Planted and Balance
A B C D
Variety Op Stock Planted Balance
Bastile 1000

Formula in C2 =SUMIF(Sheet1!B:B,A2,Sheet1!C:C)
Formula in D2 =B2-C2

Regards

Roger Govier