Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Create summary based on specifc value in a different sheet
I am preparing an Excel template for my users to help them calculate compound interest rate over several years based on the interest rate of a bank. The first sheet contains 3 columns, StartDate, EndDate, Rate. The second sheet which will be hidden to the users is for all the various calculations. There will always be a row for the amount at year end. I would like to produce a summary in the third sheet with the interest and the total amount at end of each year and at the end of the period. I know I can use pivot table but since it is an Excel template, I cannot pre-define the criteria. Is there a way to achieve that without using VBA? -- RayYeung ------------------------------------------------------------------------ RayYeung's Profile: http://www.excelforum.com/member.php...o&userid=25343 View this thread: http://www.excelforum.com/showthread...hreadid=388241 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to create summary of expense report? | Excel Worksheet Functions | |||
Create a report with selected rows based on the content in a cell | New Users to Excel | |||
Can I create an order summary report in Excel? | Excel Worksheet Functions | |||
how to create and use a new spreadsheet based on a template | Excel Discussion (Misc queries) | |||
Create a total based on multiple conditions is not giving correct. | Excel Worksheet Functions |