Results 1 to 6 of 6

Is there any formula that can mark certain number of cells, being dependent from one cell

Threaded View

  1. #1
    Registered User
    Join Date
    08-24-2018
    Location
    Aarhus Denmark
    MS-Off Ver
    Office 365
    Posts
    16

    Is there any formula that can mark certain number of cells, being dependent from one cell

    In this Case I would Like Excel To Sum up amount of cells in Row E which is stated by cell B45 (3). In this example E33 E34 and E35 = 45.
    With Column D I would like it to mark last digits, that are stated by cell C45 (9). In this example it is D36-D44 = 48
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 07-15-2016, 03:46 PM
  2. [SOLVED] Require a formula to average a certain number of cells dependent on another cell
    By zimmerlong in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 08-05-2015, 08:37 PM
  3. Budget Mark-ups dependent on certain total
    By lblair616 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-01-2014, 04:02 PM
  4. How to Mark a Cell with a specified Number of interval
    By kretos88 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-05-2013, 04:43 PM
  5. Formula to mark cell to input number into it
    By PaStan in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-18-2013, 05:02 PM
  6. Populating a number of cells dependent on the value of another cell
    By supachoc in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-12-2010, 02:00 PM
  7. Formula to return column heading dependent on number in cell
    By Reidm in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-31-2008, 05:04 AM

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