Excel

S

Stephen

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
 
C

CLR

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

Vaya con Dios,
Chuck, CABGx3
 
S

Stephen

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
 
Top