Hi,
I am running a spreadsheet to check amount of fuel put into the company vehicles. I have a number of columns, but the ones that I need are Reg. No and Total Input. Now, I would like to set something up that will automatically calculate the total fuel input of a particular reg. To illustrate:
Reg: Input:
R717 25
S283 34
R716 18
R717 25
S283 34
R716 18
Total (I would prefer this to be in another worksheet)
Reg: Total Input:
R717 50
S283 68
R716 36
However, there are about 17 vans, and I already have nearly 200 entries for the month of April, as they fill up perhaps twice a day. It is probably very easy - I hope so anyway - can anyone help me?
Cheers.
Markus.
I am running a spreadsheet to check amount of fuel put into the company vehicles. I have a number of columns, but the ones that I need are Reg. No and Total Input. Now, I would like to set something up that will automatically calculate the total fuel input of a particular reg. To illustrate:
Reg: Input:
R717 25
S283 34
R716 18
R717 25
S283 34
R716 18
Total (I would prefer this to be in another worksheet)
Reg: Total Input:
R717 50
S283 68
R716 36
However, there are about 17 vans, and I already have nearly 200 entries for the month of April, as they fill up perhaps twice a day. It is probably very easy - I hope so anyway - can anyone help me?
Cheers.
Markus.