| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to Evaluate Range and Sum Different Column
I have a loan ammortization that I would like to compute yearly interest on
without having to go into the schedule and add subtotals for each year. Dates are stored in column F and Interest is stored in column I. The formula needs to look at column F and determine where a year starts and stops (assume 2008 for this example) and then sum the corresponding cells in I. Any help is appreciated. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| =EVALUATE("{ to work in a range of cells | Excel Worksheet Functions | |||
| Evaluate a column and extract last value | Excel Worksheet Functions | |||
| want sumif function's range to evaluate 2 columns | Excel Worksheet Functions | |||
| VB evaluate a value in a table's column and display msgbox | Excel Discussion (Misc queries) | |||
| HOW to Evaluate a range with IF ? | Excel Discussion (Misc queries) | |||
Threaded Mode
