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(