| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum based on conditions
Ok, I need a formula to give me a summed date based on the rank
ex. if rank=1 then due date = start date + 5 if rank=2 then due date = start date + 3 if rank=3 then due date = start date + 1 Date Started(A) Rank(D) Due Date (E) 5/10/06 1 5/15/06 5/08/06 2 5/11/06 5/9/06 3 5/10/06 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Total or Count based on multiple conditions | Excel Discussion (Misc queries) | |||
| Add cells from a range based on 2 conditions from 2 other ranges | Excel Worksheet Functions | |||
| SUM based on multiple conditions - SORRY, URGENT!!! | Excel Worksheet Functions | |||
| Create a total based on multiple conditions is not giving correct. | Excel Worksheet Functions | |||
| SUMIF based on 2 conditions | Excel Worksheet Functions | |||
Threaded Mode
