| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Within another function calculate and sum number of days
How can a use a function within a function:
The spread sheet has three columns for this example: A - Start Date B - End Date C - Status For those rows that match the status criteria "Done" I wish to calculate the number of networkdays between the Start and End dates and add it to a total. I have tried "SUMIF" but "Sum_range" does not seem to accept the calculation. Thank you in advance for your help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate Number of Days in a Month | Excel Worksheet Functions | |||
| How do I calculate the number of business days? | Excel Discussion (Misc queries) | |||
| calculate number of days btw dates | Excel Worksheet Functions | |||
| Function to calculate the number of years, months and days between | Excel Worksheet Functions | |||
| calculate number of working days | Excel Worksheet Functions | |||
Threaded Mode
