Before you call me nuts - hear me out:
I have a list for vehicle gas usage by date. i would like to sort the
vehicle column and then get a subtotal by money spent for gas.

When I use Dat the subtotal and SUM I get zero because it is a text field.
I want to SUM on the cost spent per vehicle.

Any suggestions?
--
Is it the times or the Zeitgiest?