Excel
 

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

Excel
 

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

Excel
 

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

Excel
 

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

Excel
 

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