+ Reply to Thread
Results 1 to 2 of 2

Combine SUBTOTAL and AVERAGEIF

  1. 01-27-2014, 04:41 PM #1
    CUFF
    CUFF is offline
    Registered User
    Join Date
    01-27-2014
    Location
    Birmingham, Alabama, USA
    MS-Off Ver
    Excel 2010
    Posts
    4

    Combine SUBTOTAL and AVERAGEIF

    Can anyone tell me how I could combine these two functions?

    =SUBTOTAL(1,A1:A10O) and AVERAGEIF(A1:A100,">0")
    Last edited by CUFF; 01-27-2014 at 05:15 PM. Reason: shorten message
    Reply With QuoteRegister To Reply
  2. 01-27-2014, 08:06 PM #2
    vlady
    vlady is offline
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: Combine SUBTOTAL and AVERAGEIF

    Welcome to the forum.




    Mod Note: Copy already in proper subforum.
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir
    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 to combine Subtotal, Sumifs and more
    By Tipler93 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 01-23-2014, 12:12 PM
  2. Combine Subtotal and Sumif
    By Rompetelo in forum Excel General
    Replies: 4
    Last Post: 12-12-2012, 09:20 AM
  3. 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
  4. How to combine SUBTOTAL function with ABS
    By efernandes67 in forum Excel General
    Replies: 3
    Last Post: 11-30-2007, 03:45 PM
  5. 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