What I want to do is average all the work miles _minus_ the Rec miles.
(Rec - recreation)
eg.
Col A-F:
5-Jul / Tue/ 64522/ 64542/ 20/ John - Meinecke St / Hayward
6-Jul/ Wed/ 64542/ 64562/ 20/ George St. - San Luis
7-Jul/ Thu/ 64562/ 64612/ 50/ John - Murray / Hayward Lumber/ De Cou
8-Jul Fri 64612 64690 78 Creston CA - Peg's deck
9-Jul Sat 64690 64776 86 Creston CA - Peg's deck
10-Jul Sun 64776 64790 14 Rec
I want to total all the work miles and compute the daily average, but
subtract all the rec (recreation) miles. But each work day may have
different names. Can I compute a formula to add up all the miles and
then subtract the Rec miles?
(In this eg. E= daily miles/F=destination. I had them switched around
in my original question - sorry)
Thanks for your help & replies, B. I hope this is clear what I want to
do.
michaelas
--
michaelas
------------------------------------------------------------------------
michaelas's Profile:
http://www.excelforum.com/member.php...o&userid=26573
View this thread:
http://www.excelforum.com/showthread...hreadid=466654