Function help needed please

[Ian Harris]

Hi
How can I do the following I have five columns
Col 1 Mileage counter start
Col 2 Mileage counter end
Col 3 Mileage done (total from start to end column )
Col 4 Mileage Purpose (this will be entered as either Business Or
Personal)
Col 5 Mileage cost
I need to work cost of mileage done at a rate £0.12p per mile only if it has
business in third column this needs to be done on daily basis whilst still
keeping a record of all mileage totals be it business or personal

Hope this explains my problem ok
Many thanks
Ian

 

[Frank Kabel]

Hi Ian
one way (I thin the business purpose is in column D):
=SUMIF($D$2:$D$999;"Business";$C$2:$C$999)*0,12

Of course you can put the rate per mile in a dedicated cell and replace
*0,12 with a reference to this cell:
=SUMIF($D$2:$D$999;"Business";$C$2:$C$999)*$G$1
If G1 stores the rate

HTH
Frank

 

[Bob Phillips]

Ian,

In F1

=IF(D1="Business",C1*E1,"")

and just total them

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Ian Harris]

Many thanks for you help guys