I have a taxi Company and I have created a spreadsheet for all the jobs that
have come into the office but every night i have to go through and count
individual amount that the drivers have taken for that day I need a fomular
that will give me a individual running acount of what each driver has earnt
that day ie:

Driver Time Address Destination price
1 10.15 3.80
2 10.30 2.60
3 10.40 5.50
2 11.10 10.00
3 11.15 27.00
1 11.30 5.00

and so on I need a fomular that will add each drivers total for the day

Have a look in the help index for SUMIF

--
Don Guillett
SalesAid Software

"Stephen" wrote in message
...
I have a taxi Company and I have created a spreadsheet for all the jobs
that
have come into the office but every night i have to go through and count
individual amount that the drivers have taken for that day I need a
fomular
that will give me a individual running acount of what each driver has
earnt
that day ie:

Driver Time Address Destination price
1 10.15 3.80
2 10.30 2.60
3 10.40 5.50
2 11.10 10.00
3 11.15 27.00
1 11.30 5.00

and so on I need a fomular that will add each drivers total for the day

You might want to check out the Data SubTotals feature.....

Vaya con Dios,
Chuck, CABGx3

"Stephen" wrote in message
...
I have a taxi Company and I have created a spreadsheet for all the jobs
that
have come into the office but every night i have to go through and count
individual amount that the drivers have taken for that day I need a
fomular
that will give me a individual running acount of what each driver has
earnt
that day ie:

Driver Time Address Destination price
1 10.15 3.80
2 10.30 2.60
3 10.40 5.50
2 11.10 10.00
3 11.15 27.00
1 11.30 5.00

and so on I need a fomular that will add each drivers total for the day

Thank you for you help I have sorted out one problem with the fomula
=SUMIF(a2:a7,"1",B2:B7) which gave me the answer but when I press the enter
button the fomula show up in the cell not the answer what do I have to add to
this fomula to see the answer and not the fomula

"Don Guillett" wrote:

Have a look in the help index for SUMIF

--
Don Guillett
SalesAid Software

"Stephen" wrote in message
...
I have a taxi Company and I have created a spreadsheet for all the jobs
that
have come into the office but every night i have to go through and count
individual amount that the drivers have taken for that day I need a
fomular
that will give me a individual running acount of what each driver has
earnt
that day ie:

Driver Time Address Destination price
1 10.15 3.80
2 10.30 2.60
3 10.40 5.50
2 11.10 10.00
3 11.15 27.00
1 11.30 5.00

and so on I need a fomular that will add each drivers total for the day

try formatting as general instead of text

--
Don Guillett
SalesAid Software

"Stephen" wrote in message
...
Thank you for you help I have sorted out one problem with the fomula
=SUMIF(a2:a7,"1",B2:B7) which gave me the answer but when I press the
enter
button the fomula show up in the cell not the answer what do I have to add
to
this fomula to see the answer and not the fomula

"Don Guillett" wrote:

Have a look in the help index for SUMIF

--
Don Guillett
SalesAid Software

"Stephen" wrote in message
...
I have a taxi Company and I have created a spreadsheet for all the jobs
that
have come into the office but every night i have to go through and
count
individual amount that the drivers have taken for that day I need a
fomular
that will give me a individual running acount of what each driver has
earnt
that day ie:

Driver Time Address Destination price
1 10.15 3.80
2 10.30 2.60
3 10.40 5.50
2 11.10 10.00
3 11.15 27.00
1 11.30 5.00

and so on I need a fomular that will add each drivers total for the day