+ Reply to Thread
Results 1 to 3 of 3

subtotal formula for Google

Hybrid View

  1. 09-15-2020, 11:20 AM #1
    Berna11
    Berna11 is offline
    Forum Contributor
    Join Date
    05-16-2012
    Location
    Latina, ITALY
    MS-Off Ver
    Excel 2010--2016
    Posts
    947

    subtotal formula for Google

    Good evening, if possible, I need your help
    to transform the subtotal formula from Escel to
    Google Spreadsheet.
    The formula in Excel is working

    =SUMPRODUCT(SUBTOTAL(3,OFFSET(C8:C33,ROW(C8:C33)-MIN(ROW(C8:C33)),,1))*(C8:C33="W"))/SUBTOTAL(3,C8:C33)
    Thank you
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 09-21-2020, 04:19 AM #2
    Bo_Ry
    Bo_Ry is offline
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,213

    Re: subtotal formula for Google

    GoogleSheet require helper column

    D8
    =INDEX(N(C8:C="W"))

    B5
    =SUBTOTAL(9,D8:D)/SUBTOTAL(3,B8:B)
    Linkedin/Bo-Rydobon
    Youtube.com/XcWizard
    Facebook.com/XcWizard
    Reply With QuoteRegister To Reply
  3. 09-24-2020, 03:55 AM #3
    Berna11
    Berna11 is offline
    Forum Contributor
    Join Date
    05-16-2012
    Location
    Latina, ITALY
    MS-Off Ver
    Excel 2010--2016
    Posts
    947

    Re: subtotal formula for Google

    Thank you
    as always useful
    Hello
    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. Sorting by Alpha, Adding Subtotal - then removing subtotal - variable data sets
    By gregg_grug in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-03-2019, 07:41 PM
  2. Google Sheet & Google Docs
    By asherryan in forum Excel General
    Replies: 1
    Last Post: 09-21-2018, 08:48 AM
  3. email row contents based on cell values (google sheets populated by google forms)
    By reedg in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 01-13-2016, 02:55 PM
  4. VBA Route Calculator - Google Maps Api 22 Minutes quicker than Actual Google Website
    By lookingforhelp1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-06-2015, 01:23 PM
  5. SUBTOTAL ... used in complex if-then results in assumption of SUBTOTAL usage on True logic
    By vfrost in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-18-2013, 04:10 PM
  6. Subtotal - Delete zero Subtotal and prior rows that calculate to that zero Subtotal
    By Whatsherface in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-14-2012, 08:37 PM
  7. [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

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