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


Gimme wrote:
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