Vicky to assist in giving you the correct solution more info is required from
you:
e.g. what is the "layout" of your data? (column headings, number of rows used)
You may well be looking for a SUMPRODUCT formula but clearly any formula
needs to refer to cells and without knowing the layout nobody can really
develop a formula for you.

"Thicky Vicky!!! :O(" wrote:

Ok,i have a spreadsheet with toll bridge charges for mon - fri and costs on
cars,trucks & motor bikes, plus the number of vehicles been through the toll
each day......i have to calculate with one formula the daily amount taken in
money...starting with monday then being able to drag this down through every
day to fri.............................My brain has imploded!!!......i've
been sat here for hours trying to do the formula and just can't get it
right!!!!................please help as i feel i am just as thick as a plank
of wood,and i know it is really simple!!! :O(

Gary thought that the project was a bit more complicated

Toll charges Price
car £1.50
lorry £3.50
motor bike £0.00

say the list of charges is in cells B1 to C4.

Day cars lorries motor bikes total raised
Mon 345 250 327 £517.50
Tues 400 220 150 £600.00
Weds 467 565 466 £700.50
Thurs 222 177 202 £333.00
Fri 872 439 189 £1,308.00
Total £3,459.00

The following is in B6 to F12

the formula for F7 is:
=C7*$C$2+D78*$C$3+E7*$C$4

The $ signs in the range address $C$2 fix the cell so that when it is copied
it reamins the same. The cell C7 will change to C8 when it is copied down.

Select the cell F6 and move the mouse over the the bottom right of the cell
until the cursor changes to a + sign; hold down the left mouse button and
drag down to F11. This will copy the formula down.

If this method is difficult here is another way.
Select F6.
Press CTRL + C (Hold down Ctrl while pressing C) you will see the cell
surounded by 'marching ants'.
Select F7 to F11 (Select F7 hold shift and keep pressing the down arrow)
Press enter

Your formulas will be entered.

The total
In E12 type Total
In F12 type or copy the the formula
=SUM(F7:F11)

Hope this helps.
Good luck

Ps you can type numbers in the UK! If you do not have a number pad use the
numbers over the qwerty keyboard.

Peter

"Thicky Vicky!!! :O(" wrote:

Hi,
Well the cars etc prices are up the top seperate and the rest is below :-
Toll charges price
car £1.50
lorry £3.50
motor bike £0.00

cars lorries motor bikes total raised
Mon 345 250 327
Tues 400 220 150
Weds 467 565 466
Thurs 222 177 202
Fri 872 439 189

This is basically what it looks like............and i dont know if it makes
a difference but i am using uk version so i can't put the totals in numbers
as you would if it was usa!......feel really thick...i know its simple enough
but my brain is fried!!:O(
Vic
--
Thicky Vicky :O(


"Ron@Buy" wrote:

Vicky to assist in giving you the correct solution more info is required from
you:
e.g. what is the "layout" of your data? (column headings, number of rows used)
You may well be looking for a SUMPRODUCT formula but clearly any formula
needs to refer to cells and without knowing the layout nobody can really
develop a formula for you.

"Thicky Vicky!!! :O(" wrote:

Ok,i have a spreadsheet with toll bridge charges for mon - fri and costs on
cars,trucks & motor bikes, plus the number of vehicles been through the toll
each day......i have to calculate with one formula the daily amount taken in
money...starting with monday then being able to drag this down through every
day to fri.............................My brain has imploded!!!......i've
been sat here for hours trying to do the formula and just can't get it
right!!!!................please help as i feel i am just as thick as a plank
of wood,and i know it is really simple!!! :O(

Glad I could help. Don't worry, everyone feels stupid with computers at some
time.

Peter

"Thicky Vicky!!! :O(" wrote:

Of course!!!............i knew it was simple i forgot the fixed
cell!!................jesus i feel like a right pillock
now!!!lol............thanks hun!
--
Thicky Vicky :O(


"Billy Liddel" wrote:

Gary thought that the project was a bit more complicated

Toll charges Price
car £1.50
lorry £3.50
motor bike £0.00

say the list of charges is in cells B1 to C4.

Day cars lorries motor bikes total raised
Mon 345 250 327 £517.50
Tues 400 220 150 £600.00
Weds 467 565 466 £700.50
Thurs 222 177 202 £333.00
Fri 872 439 189 £1,308.00
Total £3,459.00

The following is in B6 to F12

the formula for F7 is:
=C7*$C$2+D78*$C$3+E7*$C$4

The $ signs in the range address $C$2 fix the cell so that when it is copied
it reamins the same. The cell C7 will change to C8 when it is copied down.

Select the cell F6 and move the mouse over the the bottom right of the cell
until the cursor changes to a + sign; hold down the left mouse button and
drag down to F11. This will copy the formula down.

If this method is difficult here is another way.
Select F6.
Press CTRL + C (Hold down Ctrl while pressing C) you will see the cell
surounded by 'marching ants'.
Select F7 to F11 (Select F7 hold shift and keep pressing the down arrow)
Press enter

Your formulas will be entered.

The total
In E12 type Total
In F12 type or copy the the formula
=SUM(F7:F11)

Hope this helps.
Good luck

Ps you can type numbers in the UK! If you do not have a number pad use the
numbers over the qwerty keyboard.

Peter

"Thicky Vicky!!! :O(" wrote:

Hi,
Well the cars etc prices are up the top seperate and the rest is below :-
Toll charges price
car £1.50
lorry £3.50
motor bike £0.00

cars lorries motor bikes total raised
Mon 345 250 327
Tues 400 220 150
Weds 467 565 466
Thurs 222 177 202
Fri 872 439 189

This is basically what it looks like............and i dont know if it makes
a difference but i am using uk version so i can't put the totals in numbers
as you would if it was usa!......feel really thick...i know its simple enough
but my brain is fried!!:O(
Vic
--
Thicky Vicky :O(


"Ron@Buy" wrote:

Vicky to assist in giving you the correct solution more info is required from
you:
e.g. what is the "layout" of your data? (column headings, number of rows used)
You may well be looking for a SUMPRODUCT formula but clearly any formula
needs to refer to cells and without knowing the layout nobody can really
develop a formula for you.

"Thicky Vicky!!! :O(" wrote:

Ok,i have a spreadsheet with toll bridge charges for mon - fri and costs on
cars,trucks & motor bikes, plus the number of vehicles been through the toll
each day......i have to calculate with one formula the daily amount taken in
money...starting with monday then being able to drag this down through every
day to fri.............................My brain has imploded!!!......i've
been sat here for hours trying to do the formula and just can't get it
right!!!!................please help as i feel i am just as thick as a plank
of wood,and i know it is really simple!!! :O(