| Home |
| Search |
| Today's Posts |
|
#7
|
|||
|
|||
Thanks JE,
IT works perfectly, Dave JE McGimpsey wrote in : Yeah, I didn't think that through very well. Try this in D3, and copy down: =SUMPRODUCT(--(C3$J$2:$J$4),(C3-$J$2:$J$4),$L$2:$L$4)-SUM(D$2:D2) In article , asdfasdf wrote: One problem is with the cells for future months with nothing entered. Here is what I get. Monthly YTD running total Amt Owed 50000 50000 15000 49000 99000 14700 11000 110000 18600 0 110000 14700 0 110000 18600 0 110000 14700 0 110000 18600 0 110000 14700 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Looking for a temlate for sales and commission input? | Excel Discussion (Misc queries) | |||
| sales commission template | Excel Discussion (Misc queries) | |||
| Calculating commission schedule (will pay for help!) | Excel Worksheet Functions | |||
| Calculating commission schedule (will pay for help!) | Excel Worksheet Functions | |||
| Calculating commission schedule (will pay for help!) | Excel Worksheet Functions | |||
Threaded Mode
