Excel

[Guest]

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

 

[Don Guillett]

Have a look in the help index for SUMIF

 

[CLR]

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

Vaya con Dios,
Chuck, CABGx3

 

[Guest]

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]

try formatting as general instead of text