+ Reply to Thread
Results 1 to 4 of 4

Change formula when cell content changes?

  1. 03-10-2013, 09:09 PM #1
    Margate
    Margate is offline
    Forum Contributor
    Join Date
    01-18-2013
    Location
    England
    MS-Off Ver
    2016 (Mac)
    Posts
    149

    Change formula when cell content changes?

    Hello Everyone!

    Cell AD11 has the following formula:
    =SUM(D$11:M$11)

    How to I set this formula (in cell AD11) to automatically change when cell C9 changes?
    Cell AD11 just adds up the SUM of a row of cells. What I want to do however
    is have this formula change whenever the value of cell C9 changes (days worked).

    Cell C9 has a drop menu that contains numbers from 8 to 25. If a user chooses
    (for example) 12 from the drop menu (in cell C9) I want the formula in cell AD11 to
    change to: =SUM(D$11:O$11). The formula would need to change accordingly depending on
    what number was chosen from the drop menu.

    Additionally I need to this to happen to 25 cells whenever the number of days are
    changed in cell C9.


    I have tried numerous ways to doing this but to no avail!

    Thank you very much for any help.

    Margate
    Reply With QuoteRegister To Reply
  2. 03-10-2013, 09:15 PM #2
    dredwolf
    dredwolf is offline
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: Change formula when cell content changes?

    What is the formula supposed to change to?

    Edit-

    found it..

    so basically, the number chosen in C determines how many columns to sum?
    Last edited by dredwolf; 03-10-2013 at 09:17 PM.
    A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
    -Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
    -To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
    If you received helpful response, please remember to hit the * of that post
    Reply With QuoteRegister To Reply
  3. 03-10-2013, 09:20 PM #3
    dredwolf
    dredwolf is offline
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: Change formula when cell content changes?

    Try:
    =SUM(OFFSET($D$11,,,,$C$9))

    Hope this helps
    Reply With QuoteRegister To Reply
  4. 03-10-2013, 10:15 PM #4
    Tony Valko
    Tony Valko is offline
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Change formula when cell content changes?

    Here's a non-volatile formula:

    =SUM(D11:INDEX(D11:AB11,C9))

    Note that if C9 is an empty cell the formula will calculate the entire range D11:AB11.
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1