LOOKUP function??

[banzaine]

Hi - i am collecting data from various sequential production batches. For each given batch, i have one entry in each data column, but in different rows. I need to be able to subtract a value from one column / row from another in a different column / row. Cells apart from those with the single data entries are blank. I think i may need the LOOKUP function, but cannot picture how
Thanks for any advice
Nick

[JBeaucaire]

Your sample sheet should manually mockup your desired results. What/where is the answers?

[banzaine]

Sorry if i didnt make clear what i wanted - basically i want to be able to produce a summary table as shown to the right of the data table.
thanks Nick

Time Batch A B
01:00 1
02:00 1 10 Summary Batch A-B
03:00 1 1 8
04:00 1 2 2 6
05:00 1 3 6
06:00 1
07:00 1
08:00 1
09:00 2
10:00 2
11:00 2 9
12:00 2
13:00 2
14:00 2
15:00 2 3
16:00 2
17:00 2
18:00 2
19:00 2
20:00 2
21:00 3
22:00 3
23:00 3 10
00:00 3
01:00 3 4
02:00 3
03:00 3

[banzaine]

Sorry if i didnt make clear what i wanted - basically i want to be able to produce a summary table as shown to the right of the data table.
thanks Nick

Answers to the calculation would be batch 1 (10-2=8), batch 2 (9-3=6), batch 3 (10-4=6)

Please see updated xls

[JBeaucaire]

Put this formula in H2 and copy down:

=SUMIF(B:B,G4,C:C)-SUMIF(B:B,G4,D:D)

[JBeaucaire]

A Pivot Table does the job, too.

[banzaine]

Superb - thankyou for your help