|
» 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)) |
| Screenshot // Summing Values In a Range Specified By Indirect Cell References |
  |
|
RATING:
2.61
VIEWS: 19036 |
||||
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))
Sponsors:
 |
Book Store:
Recommended Books:
- Microsoft Office XP Introductory Concepts and Techniques
- Guide to Financial Reporting and Analysis
- The McGraw-Hill 36-Hour Course in Finance for Nonfinancial Managers
- Financial Statement Analysis: A Practitioner's Guide, 3rd Edition
- Investing for Dummies, Third Edition
- F1 Get the Most out of Excel! The Ultimate Excel tip Help Guide
Related MS EXCEL TIPS:
Terms
and Conditions of use
The applications/code on this site are distributed as is and without warranties
or liability. In no event shall the owner of the copyrights, or the authors
of the applications/code be liable for any loss of profit, any problems
or any damage resulting from the use or evaluation of the applications/code.
=IF(ISBLANK(A4),"",RANK(A4,A:A))