Results 1 to 3 of 3

Adding a Formula After an Array?

Threaded View

EricDonk Adding a Formula After an... 04-05-2023, 12:15 PM
Bernie Deitrick Re: Adding a Formula After an... 04-05-2023, 01:44 PM
EricDonk Re: Adding a Formula After an... 04-05-2023, 01:55 PM
  1. #1
    Registered User
    Join Date
    11-14-2022
    Location
    England
    MS-Off Ver
    MS365 (PC) Version 2502
    Posts
    62

    Question Adding a Formula After an Array?

    Hi again,

    I was wondering if there's a way to have a formula calculate at bottom of an array formula? With the obvious kicker being that the array can vary in length.
    I have attached a sample book and expected results, although it doesn't necessarily highlight the issue clearly because the array in question changes regularly which makes adding a formula to the bottom of it very difficult (for me at least)

    I am using MS365 Excel v2208 on PC.

    Thanks for your time.
    Attached Files Attached Files
    Last edited by EricDonk; 04-05-2023 at 12:42 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] error adding a formula in an array
    By fabdav in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-12-2018, 02:47 PM
  2. [SOLVED] adding a IF function to an array formula? is this possible?
    By cnak in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-17-2017, 09:42 AM
  3. [SOLVED] Adding another condition into array formula
    By simmo86 in forum Excel General
    Replies: 3
    Last Post: 01-19-2017, 09:59 AM
  4. [SOLVED] Adding another If Statement to an array formula
    By SJohnsonbaugh in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-16-2016, 12:30 PM
  5. Adding criteria to an array formula
    By jonagpa in forum Excel Formulas & Functions
    Replies: 21
    Last Post: 01-09-2016, 11:28 PM
  6. Adding IF to an Array formula
    By Motox in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-18-2015, 08:51 AM
  7. adding Indirect formula to my current sum if array formula
    By Eastbay2 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 05-13-2013, 09:41 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1