Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formating cells
I'm working on a timesheet, I have three columns for hours spent per day 1)
regular 2) overtime 3) other. The reuglar and overtime columns add and calculate as I want, but for other I have certain criteria I would like to add. I have added a column for other hours codes (H=holiday, S=Sick, V=Vacation), I would like to add my columns dependent on that code. Lets say P22:P28 If Q22:Q28=A. Is this possible? And would there be a problem if ther were a sick day, vacation day, and a holiday in the same week? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formating cells
It sounds like you need to look at the SUMIF function. Check this out:
http://www.ozgrid.com/Excel/sum-if.htm There are a lot more resources if you google SUMIF. Dave -- Brevity is the soul of wit. "gerry" wrote: I'm working on a timesheet, I have three columns for hours spent per day 1) regular 2) overtime 3) other. The reuglar and overtime columns add and calculate as I want, but for other I have certain criteria I would like to add. I have added a column for other hours codes (H=holiday, S=Sick, V=Vacation), I would like to add my columns dependent on that code. Lets say P22:P28 If Q22:Q28=A. Is this possible? And would there be a problem if ther were a sick day, vacation day, and a holiday in the same week? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
combine 2 cells but keep formating of each individual cell | Excel Worksheet Functions | |||
Conditional Formating a Block of Cells | Excel Discussion (Misc queries) | |||
formating cells using formula rather than menus/VBA | Excel Worksheet Functions | |||
Formating Worksheet Cells | Excel Discussion (Misc queries) | |||
Formating text in cells | Excel Discussion (Misc queries) |