Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am trying to do a time sheet i want it to add across so that X number of
regular hours goes to cell J4 and X number of overtime hours goes to cell k4 and so on i tried using the sum if but not sure if I am using right or if it is the right formula.I want to be able to but in each cell like 4S 4R and it add to proper column so if Monday was 8R Tuesday 4S and 4R then it would show cell J4 as 12 and cell L4 as 4. Please help. NAME ID # MON TUES WED THUR FRI SAT 8 R |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Counting # of Formulas in a column with formulas and entered data | Excel Worksheet Functions | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
automatically copy formulas down columns or copy formulas all the | Excel Worksheet Functions | |||
Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
formulas for changing formulas? | Excel Discussion (Misc queries) |