+ Reply to Thread
Results 1 to 17 of 17

Average ifs for filtered data

Hybrid View

Mikes_KM Average ifs for filtered data 06-16-2019, 06:14 AM
AliGW Re: Average ifs for filtered... 06-16-2019, 06:15 AM
AliGW Re: Average ifs for filtered... 06-16-2019, 06:19 AM
Mikes_KM Re: Average ifs for filtered... 06-16-2019, 06:25 AM
kvsrinivasamurthy Re: Average ifs for filtered... 06-16-2019, 11:24 AM
Mikes_KM Re: Average ifs for filtered... 06-16-2019, 12:15 PM
AliGW Re: Average ifs for filtered... 06-16-2019, 12:19 PM
Mikes_KM Re: Average ifs for filtered... 06-16-2019, 12:42 PM
CARACALLA Re: Average ifs for filtered... 06-16-2019, 01:06 PM
Mikes_KM Re: Average ifs for filtered... 06-16-2019, 01:26 PM
CARACALLA Re: Average ifs for filtered... 06-16-2019, 01:29 PM
Mikes_KM Re: Average ifs for filtered... 06-16-2019, 01:59 PM
Mikes_KM Re: Average ifs for filtered... 06-16-2019, 05:51 PM
Mikes_KM Re: Average ifs for filtered... 06-16-2019, 06:45 PM
kvsrinivasamurthy Re: Average ifs for filtered... 06-17-2019, 12:51 AM
Mikes_KM Re: Average ifs for filtered... 06-22-2019, 06:58 PM
kvsrinivasamurthy Re: Average ifs for filtered... 06-22-2019, 09:44 PM
  1. 06-16-2019, 01:26 PM #1
    Mikes_KM is offline
    Registered User
    Join Date
    06-15-2019
    Location
    London, England
    MS-Off Ver
    2016
    Posts
    25

    Re: Average ifs for filtered data

    Hi Carracalla,

    Because I am trying to find the average only if is a win.
    B2=SUBTOTAL(101,Table1[Total PnL]) shows the average for both win and loss.

    Thanks Though
    Reply With QuoteRegister To Reply
  2. 06-16-2019, 01:29 PM #2
    CARACALLA is offline
    Forum Expert
    Join Date
    09-25-2015
    Location
    Milan Italy
    MS-Off Ver
    office 365
    Posts
    1,988

    Re: Average ifs for filtered data

    Filter table for win
    Reply With QuoteRegister To Reply
  3. 06-16-2019, 01:59 PM #3
    Mikes_KM is offline
    Registered User
    Join Date
    06-15-2019
    Location
    London, England
    MS-Off Ver
    2016
    Posts
    25

    Re: Average ifs for filtered data

    Ohh nice, this is an alternative way. Thanks
    I will play about with my original spreadsheet to get it to fit well with my data.
    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. trying to get an average of filtered data
    By greggatz in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-07-2014, 07:20 PM
  2. Average of filtered data
    By Benjamin in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 03:05 AM
  3. Average of filtered data
    By Benjamin in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 02:05 AM
  4. Average of filtered data
    By Benjamin in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 01:05 AM
  5. [SOLVED] Average of filtered data
    By Benjamin in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 12:05 AM
  6. [SOLVED] Average of filtered data
    By Benjamin in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-05-2005, 10:05 PM
  7. Average of filtered data
    By Benjamin in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-03-2005, 10:05 AM

Tags for this Thread

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