CATEGORY: Summing VERSIONS: All Microsoft Excel Versions

Problem: Column A contains a list of numbers. Columns B:C contain pairs of cell references, representing the beginning and end of a specific range from column A, which we would like to sum. How could we create a formula that will sum the values included in each of the ranges specified in columns B:C? Solution: Using the INDIRECT function, as follows: =SUM(INDIRECT(B2&"":""&C2))

Screenshot // Summing Values In a Range Specified By Indirect Cell References

Rate this tip 1 2 3 4 5   RATING: 2.61   VIEWS: 16466 Email Tip Print Tip Add to My Tips

READER COMMENTS (view all comments)

Summing Values In a Range Dennis Taylor wrote on July 14, 2005 23:43 EST If you enter this formula in cell B4 and then copy it downward into as many cells you think you will need, it will give you correct answers. Perhaps less elegant than using the OFFSET function, but I think it's more direct and more comprehensible. =IF(ISBLANK(A4),"",RANK(A4,A:A)) Wrong comment posting Dennis Taylor wrote on July 15, 2005 03:21 EST My previous posted comments should have gone to this topic: Ranking numbers in a dynamic list error in indirect formula Bill Cohen wrote on December 31, 1969 19:00 EST » Summing Values In a Range Specified By Indirect Cell References CATEGORY: Summing VERSIONS: All Microsoft Excel Versions Problem: Column A contains a list of numbers. Columns B:C contain pairs of cell references, representing the beginning and end of a specific range from column A, which we would like to sum. How could we create a formula that will sum the values included in each of the ranges specified in columns B:C? Solution: Using the INDIRECT function, as follows: =SUM(INDIRECT(B2&"":""&C2)) ... should be =SUM(INDIRECT(B2&":"&C2))

REGISTERED USERS - Click here to post comments GUESTS (Click here to register) Name Comment Title Comments

Understanding Financial Statements Harry Potter and the Order of the Phoenix (Book 5) Financial Risk Manager Handbook, Second Edition The McGraw-Hill Guide to Writing a High-Impact Business Plan: A Proven Blueprint for First-Time Entrepreneurs AWAKEN THE GIANT WITHIN : HOW TO TAKE IMMEDIATE CONTROL OF YOUR MENTAL, EMOTIONAL, PHYSICAL AND FINANCIAL Microsoft Word Version 2002 Inside Out

RELATED MICROSOFT EXCEL TIPS

Create User Forms in Microsoft Excel Using Loops in VBA in Microsoft Excel The Best Shortcut Keys in Microsoft Excel Writing Your First VBA Function in Excel Add Combo Box to a Sheet in Microsoft Excel Formulas to calculate Loan payments in Microsoft Excel Array variables using VBA in Microsoft Excel Create an Amortization Schedule in Microsoft Excel Find duplicates items in combine columns in Microsoft Excel Vlookup Formula – Organizing the Data Table

• Excel VBA books
• Accounting books
• Business Plans
• MS Office books
• Taxes books