+ Reply to Thread
Results 1 to 5 of 5

Dynamic SUM

Hybrid View

Alynace Dynamic SUM 11-15-2021, 09:20 PM
Estevaoba Re: Dynamic SUM 11-15-2021, 09:28 PM
Alynace Re: Dynamic SUM 11-16-2021, 06:58 AM
Estevaoba Re: Dynamic SUM 11-16-2021, 11:58 AM
Fluff13 Re: Dynamic SUM 11-16-2021, 12:17 PM
  1. 11-15-2021, 09:28 PM #1
    Estevaoba is offline
    Forum Expert
    Join Date
    06-05-2017
    Location
    Brazil
    MS-Off Ver
    Microsoft 365 Version 2412
    Posts
    1,515

    Re: Dynamic SUM

    Try in O2 and copy down:

    =SUMIF($I$2:$I$12;I2;$G$2:$G$12)

    Good luck!
    Reply With QuoteRegister To Reply
  2. 11-16-2021, 06:58 AM #2
    Alynace is offline
    Registered User
    Join Date
    04-25-2019
    Location
    danmark
    MS-Off Ver
    16.24
    Posts
    11

    Re: Dynamic SUM

    Thank you very much Estevaoba. It works!

    Could i please ask you for one extra functionality option?
    Could i have the formula active on if its there is "TRUE" on the same line at column N?
    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)

Similar Threads

  1. Dynamic Arrays, Dynamic Drop down list, Filters and multiple rows
    By Big_Kev007 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-09-2020, 06:35 AM
  2. [SOLVED] Populate Dynamic Array from Cell Values and write to Dynamic Range
    By TFiske in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-22-2018, 09:09 AM
  3. Dynamic Table of Store/Bank with location assignment (Dynamic Inventory)
    By x_ampl1 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-14-2017, 01:58 PM
  4. [SOLVED] XY scatter plot and 'table' for dynamic x and dynamic names from which the data is pulled
    By Geoff. in forum Excel General
    Replies: 10
    Last Post: 10-09-2014, 06:20 PM
  5. Dynamic Range Column Chart w/ Dynamic Avg Line (Excel 2007)
    By BrokenBiker in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 10-04-2012, 11:40 AM
  6. Help with copying dynamic column selected based on remote cell value and dynamic formula fill
    By ers in forum Excel General
    Replies: 0
    Last Post: 02-28-2006, 09:10 PM
  7. [SOLVED] Dynamic Range with unused formula messing up x axis on dynamic graph
    By cabybake@yahoo.com in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-02-2006, 04:10 PM

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