Hi

Presuming you have 1 (rather than '1 pint') in each of the cells, you could
use:
=SUM(A2:F2)*.4
if you milk is 40p a pint.

Hope this helps.
Andy.

"crusha" <[email protected] wrote in message
...
I'm trying to use excel to put my milk round on computer and need some
help
on how to total weekly milk sales like this
mon, tues wed, thurs, fri, sat total
1 pint 1 pint 1 pint 1pint 1 pint £2.00