Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel - Formulas

Status
Not open for further replies.
rseiler

rseiler

IS-IT--Management
Oct 31, 2002
7
US
Does anyone know a way to use the value of a cell to determine which cell to use in a formula. Example:

=SUM(CX:C25)

Where X is the value of a cell.

I tried to do something like
=SUM((C(value(B1)):C25)
but that didn't work, any ideas out there???

Thanks!!!!
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

javierdlm001
  • Locked
  • Question
Can anyone suggest an excellent free/nearly free BackUp software? 3
Replies
9
Views
316
goombawaho
goombawaho
ahm1985
  • Locked
  • Question
Opening file excel2003,2007 give me error different formate error why and how solve 1
Replies
12
Views
312
goombawaho
goombawaho
amy88
  • Locked
  • Question
how to associate .csv with excel 1
Replies
10
Views
302
amy88
amy88
sonkraus
  • Locked
  • Question
Convert excel drawing to pdf to jpg 2
Replies
7
Views
192
vacunita
vacunita
goombawaho
  • Locked
  • Question
Opening Excel file hangs computer
Replies
15
Views
260
stduc
stduc

Part and Inventory Search

Sponsor

Back
Top