Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excell function
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excell function
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can "real time" be cell function in EXCELL? | Excel Worksheet Functions | |||
Date & Time | New Users to Excel | |||
Conversion | Excel Worksheet Functions | |||
Using the mail merge function from excell | Excel Discussion (Misc queries) | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |