+ Reply to Thread
Results 1 to 3 of 3

subtotal formula for Google

  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

    Please Login or Register  to view this content.
    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,211

    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