Results 1 to 10 of 10

How to get sum and avagerage of certain text using subtotal function

Threaded View

  1. 02-12-2025, 10:14 AM #2
    windknife
    windknife is offline
    Forum Expert
    Join Date
    04-14-2009
    Location
    Taiwan
    MS-Off Ver
    Excel 2016,2019,O365
    Posts
    2,996

    Re: How to get sum and avagerage of certain text using subtotal function

    sum in L1
    =TEXT(SUM(FILTER(J2:J98,SUBTOTAL(103,OFFSET(A2,ROW(A2:A98)-MIN(ROW(A2:A98)),0)))),"[h]:mm")
    average in M1
    =AVERAGE(FILTER(J2:J98,SUBTOTAL(103,OFFSET(A2,ROW(A2:A98)-MIN(ROW(A2:A98)),0))))
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« 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. [SOLVED] Subtotal-like function for text on a filtered table
    By ericbinfet in forum Excel General
    Replies: 1
    Last Post: 01-09-2014, 04:27 PM
  2. 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
  3. SUBTOTAL VLookup #N/A How can Subtotal function ignore #N/A
    By RxMiller in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-18-2009, 01:01 PM
  4. SubTotal function. How do I keep reuse Subtotal criteria.
    By davidthegolfer in forum Excel General
    Replies: 0
    Last Post: 10-10-2006, 03:28 AM
  5. [SOLVED] Need subtotal function to return text as result
    By Alby in forum Excel General
    Replies: 0
    Last Post: 02-15-2006, 06:50 PM
  6. Embed a countif function in subtotal function?
    By Stuck at work in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-13-2006, 11:20 PM
  7. subtotal-isplaying data without using function subtotal ?
    By Marijan Glavaè in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-19-2005, 09:05 AM
  8. How do I nesting subtotal function within average function in Exc
    By Amy Yeh in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-19-2005, 04:06 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