excell function

[Guest]

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

 

[Guest]

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.