+ Reply to Thread
Results 1 to 7 of 7

Automize two spreadsheet, combine subtotal and countif

  1. 03-31-2020, 06:29 AM #1
    ValeriiRusinov
    ValeriiRusinov is offline
    Registered User
    Join Date
    03-31-2020
    Location
    Wroclaw
    MS-Off Ver
    google sheets
    Posts
    3

    Exclamation Automize two spreadsheet, combine subtotal and countif

    Hello to everyone!
    I have a problem with filters. I work in Google spreadsheet, to this description I attached xls file to better understand the problem.
    In this file you will find two tables, pay attention on the second one. Here is two columns with "SPEND" and "COMPANIES" I'm already put data in it from the first table but after using filters numbers stay the same.

    I know that function subtotal can help me but how I can combine it with function countif?

    Question: Which function I have to use for automatically change data in the second table in both columns(even if I will use filters) when I change data in the first table?
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 03-31-2020, 08:35 AM #2
    Pepe Le Mokko
    Pepe Le Mokko is offline
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,446

    Re: Automize two spreadsheet, combine subtotal and countif

    Hi and welcome
    in the future please post in the proper subforum.
    I moved it this time.
    Thanls
    How to paste Power Query code ( by Olly)
    Reply With QuoteRegister To Reply
  3. 03-31-2020, 08:43 AM #3
    ValeriiRusinov
    ValeriiRusinov is offline
    Registered User
    Join Date
    03-31-2020
    Location
    Wroclaw
    MS-Off Ver
    google sheets
    Posts
    3

    Re: Automize two spreadsheet, combine subtotal and countif

    Thank you!
    Where exactly you moved it?
    Reply With QuoteRegister To Reply
  4. 03-31-2020, 08:46 AM #4
    Pepe Le Mokko
    Pepe Le Mokko is offline
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,446

    Re: Automize two spreadsheet, combine subtotal and countif

    It is indicated on the page you are reading...
    Reply With QuoteRegister To Reply
  5. 03-31-2020, 10:37 AM #5
    Bernie Deitrick
    Bernie Deitrick is offline
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,942

    Re: Automize two spreadsheet, combine subtotal and countif

    An easy way is to use a helper column that responds to filtering: use this formula in C2

    =SUBTOTAL(3,A2:B2)

    and copy to C3:C10. Then use this formula in place of your first COUNTIF

    =COUNTIFS(B2:B10,">0.5",C2:C10,">0")

    and similarly for the second.
    Bernie Deitrick
    Excel MVP 2000-2010
    Reply With QuoteRegister To Reply
  6. 04-01-2020, 05:49 AM #6
    ValeriiRusinov
    ValeriiRusinov is offline
    Registered User
    Join Date
    03-31-2020
    Location
    Wroclaw
    MS-Off Ver
    google sheets
    Posts
    3

    Re: Automize two spreadsheet, combine subtotal and countif

    Thank you a lot!!!
    Reply With QuoteRegister To Reply
  7. 04-01-2020, 05:56 AM #7
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,593

    Re: Automize two spreadsheet, combine subtotal and countif

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    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. How can combine SUMIF and SUBTOTAL together?
    By Akatecho in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-08-2018, 02:39 AM
  2. [SOLVED] Combine SUBTOTAL and AVERAGEIF?
    By CUFF in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-28-2014, 10:19 AM
  3. Combine SUBTOTAL and AVERAGEIF
    By CUFF in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 01-27-2014, 08:06 PM
  4. How to combine Subtotal, Sumifs and more
    By Tipler93 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 01-23-2014, 12:12 PM
  5. [SOLVED] =Subtotal(countif,Range); Subtotal and countif in 1 formula [SOLVED]
    By thomas.mapua in forum Excel General
    Replies: 5
    Last Post: 01-06-2012, 11:33 AM
  6. How to combine SUBTOTAL function with ABS
    By efernandes67 in forum Excel General
    Replies: 3
    Last Post: 11-30-2007, 03:45 PM
  7. Combine Subtotal Macro
    By Harlequin in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-04-2007, 12:13 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