software

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

quot;Stephenquot; gt; wrote in message
...
gt;I have a taxi Company and I have created a spreadsheet for all the jobs
gt;that
gt; have come into the office but every night i have to go through and count
gt; individual amount that the drivers have taken for that day I need a
gt; fomular
gt; that will give me a individual running acount of what each driver has
gt; earnt
gt; that day ie:
gt;
gt; Driver Time Address Destination price
gt; 1 10.15 3.80
gt; 2 10.30 2.60
gt; 3 10.40 5.50
gt; 2 11.10 10.00
gt; 3 11.15 27.00
gt; 1 11.30 5.00
gt;
gt; and so on I need a fomular that will add each drivers total for the day
You might want to check out the Data gt; SubTotals feature.....

Vaya con Dios,
Chuck, CABGx3

quot;Stephenquot; gt; wrote in message
...
gt; I have a taxi Company and I have created a spreadsheet for all the jobs
that
gt; have come into the office but every night i have to go through and count
gt; individual amount that the drivers have taken for that day I need a
fomular
gt; that will give me a individual running acount of what each driver has
earnt
gt; that day ie:
gt;
gt; Driver Time Address Destination price
gt; 1 10.15 3.80
gt; 2 10.30 2.60
gt; 3 10.40 5.50
gt; 2 11.10 10.00
gt; 3 11.15 27.00
gt; 1 11.30 5.00
gt;
gt; 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,quot;1quot;,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

quot;Don Guillettquot; wrote:

gt; Have a look in the help index for SUMIF
gt;
gt; --
gt; Don Guillett
gt; SalesAid Software
gt;
gt; quot;Stephenquot; gt; wrote in message
gt; ...
gt; gt;I have a taxi Company and I have created a spreadsheet for all the jobs
gt; gt;that
gt; gt; have come into the office but every night i have to go through and count
gt; gt; individual amount that the drivers have taken for that day I need a
gt; gt; fomular
gt; gt; that will give me a individual running acount of what each driver has
gt; gt; earnt
gt; gt; that day ie:
gt; gt;
gt; gt; Driver Time Address Destination price
gt; gt; 1 10.15 3.80
gt; gt; 2 10.30 2.60
gt; gt; 3 10.40 5.50
gt; gt; 2 11.10 10.00
gt; gt; 3 11.15 27.00
gt; gt; 1 11.30 5.00
gt; gt;
gt; gt; and so on I need a fomular that will add each drivers total for the day
gt;
gt;
gt;

try formatting as general instead of text

--
Don Guillett
SalesAid Software

quot;Stephenquot; gt; wrote in message
...
gt; Thank you for you help I have sorted out one problem with the fomula
gt; =SUMIF(a2:a7,quot;1quot;,B2:B7) which gave me the answer but when I press the
gt; enter
gt; button the fomula show up in the cell not the answer what do I have to add
gt; to
gt; this fomula to see the answer and not the fomula
gt;
gt; quot;Don Guillettquot; wrote:
gt;
gt;gt; Have a look in the help index for SUMIF
gt;gt;
gt;gt; --
gt;gt; Don Guillett
gt;gt; SalesAid Software
gt;gt;
gt;gt; quot;Stephenquot; gt; wrote in message
gt;gt; ...
gt;gt; gt;I have a taxi Company and I have created a spreadsheet for all the jobs
gt;gt; gt;that
gt;gt; gt; have come into the office but every night i have to go through and
gt;gt; gt; count
gt;gt; gt; individual amount that the drivers have taken for that day I need a
gt;gt; gt; fomular
gt;gt; gt; that will give me a individual running acount of what each driver has
gt;gt; gt; earnt
gt;gt; gt; that day ie:
gt;gt; gt;
gt;gt; gt; Driver Time Address Destination price
gt;gt; gt; 1 10.15 3.80
gt;gt; gt; 2 10.30 2.60
gt;gt; gt; 3 10.40 5.50
gt;gt; gt; 2 11.10 10.00
gt;gt; gt; 3 11.15 27.00
gt;gt; gt; 1 11.30 5.00
gt;gt; gt;
gt;gt; gt; and so on I need a fomular that will add each drivers total for the day
gt;gt;
gt;gt;
gt;gt;