Using the value in a cell as a cell reference in a formula?

by

Use INDIRECT()

=SUM(INDIRECT(<start cell here> & ":" & <end cell here>))

More Related Contents:

  1. How to convert to percentage [closed]
  2. Calculation is wrong, Rounding wrong
  3. Sequence of numbers based on start and end value of 2 cells [closed]
  4. I have an Excel data sheet that I would like to extract data from into a new sheet
  5. Error in finding last used cell in Excel with VBA
  6. Getting unique values in Excel by using formulas only
  7. Vlookup using 2 columns to reference another
  8. Simple Pivot Table to Count Unique Values
  9. Excel UNIQUE Across Columns
  10. Ignore Duplicates and Create New List of Unique Values in Excel
  11. Excel Formula for Inventory
  12. Find last used cell in Excel VBA
  13. Two column lookup in table array using INDEX and MATCH
  14. Using UNIQUE with non-adjecent columns on different sheets
  15. Concatenate column headers if value in rows below is non-blank
  16. If two cells match, return value from third
  17. Excel: Searching for multiple terms in a cell
  18. What does — do in Excel formulas?
  19. Optimizing Excel formulas – SUMPRODUCT vs SUMIFS/COUNTIFS
  20. How do I apply a SumIf Formula in a VBA Sub? Getting Error 1004
  21. Countif With Multiple OR Criteria
  22. Dynamic chart range using INDIRECT: That function is not valid (despite range highlighted)
  23. CountIf With Filtered Data
  24. Convert from US to UK format
  25. Extract the last substring from a cell
  26. excel vlookup with multiple results
  27. How to roundup a number to the closest ten?
  28. Convert an Array Formula’s Text Results into a Usable Format
  29. Can’t pass a range to a lambda using Let and Makearray functions
  30. Unique Rank value for a subgroup within a group

Leave a Comment