Results 1 to 7 of 7

applying formulas using cell references

Threaded View

  1. #1
    Registered User
    Join Date
    12-16-2009
    Location
    Tennessee, USA
    MS-Off Ver
    Excel 2007
    Posts
    4

    applying formulas using cell references

    Hi - I'm new here. I've looked over a few pages of posts but didn't find a topic I thought would address what I would like to do.

    Suppose I have the numbers 1-10 in cells A1-A10 respectively

    suppose in cell A12 I have a value x and in cell A13 I have a value y.

    I would like to put a formula in cell A15 that sums up the values in cells Ax to Ay. For example, if the value in cell A12 is 4 and the value in cell A13 is 6, the result of the formula in cell A15 would be the sum of A4,A5,A6 = 15.

    I have had no luck coming up with a formula that does this, or in searching for a formula that does this. A little help, please?

    Thanks,
    Peter
    Last edited by NBVC; 12-19-2009 at 10:33 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1