Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
A lot of questions allready posted on this mater, but i can't seem to find
the right one. I like to sum a range b2:b32 if the range a2:a32 is a workday. A2:32 is a date which is a day of the month 1 to 31. aka day value 2010-1-1 1 2010-1-2 3 2010-1-3 6 2010-1-4 15 2010-1-5 2 etc. What will be the formula to "sum column value only for workdays"? Is this possible without creating a C-column with if-statement (if(workday(a2;3)<5;b2;0))? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Workdays | Excel Worksheet Functions | |||
Net Workdays | Excel Discussion (Misc queries) | |||
Workdays | Excel Worksheet Functions | |||
determine workdays | Excel Worksheet Functions | |||
Workdays | Excel Discussion (Misc queries) |