Results 1 to 8 of 8

How to calculate average of column B if criteria met in column a

Threaded View

yettie10ff How to calculate average of... 08-08-2017, 04:56 PM
BadlySpelledBuoy Re: How to calculate average... 08-08-2017, 04:59 PM
yettie10ff Re: How to calculate average... 08-08-2017, 05:02 PM
yettie10ff Re: How to calculate average... 08-08-2017, 05:10 PM
BadlySpelledBuoy Re: How to calculate average... 08-08-2017, 05:03 PM
BadlySpelledBuoy Re: How to calculate average... 08-08-2017, 05:13 PM
yettie10ff Re: How to calculate average... 08-08-2017, 05:17 PM
BadlySpelledBuoy Re: How to calculate average... 08-08-2017, 05:18 PM
  1. 08-08-2017, 04:56 PM #1
    yettie10ff is offline
    Registered User
    Join Date
    10-26-2010
    Location
    Denver, CO
    MS-Off Ver
    Excel 2010
    Posts
    11

    How to calculate average of column B if criteria met in column a

    In the screenshot attachment you can see 3 columns in my spreadsheet. I want to calculate the average in column B ONLY if Column A contains "GroupTweet".

    This is possible right? Thank you for any and all help!
    Attached Images Attached Images
    Last edited by yettie10ff; 08-08-2017 at 06:07 PM.
    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. Pivot table- How does excel calculate the average of a column sliced by another column?
    By trenzalore888 in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 04-07-2017, 08:45 AM
  2. Calculate Average of Column B, IF Column A has 2 criteria: >=Col G (AND) <= Col H
    By RayRay248 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-30-2015, 06:10 PM
  3. Need to calculate average for a column based on moving start column
    By BonnD in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-03-2013, 08:35 AM
  4. How to calculate average of one column, based on the values on another column
    By sadrap in forum Excel General
    Replies: 4
    Last Post: 12-12-2012, 10:37 AM
  5. How to calculate average, minimum and maximum if criteria in former column is met.
    By Hadekkk in forum Excel General
    Replies: 8
    Last Post: 06-26-2012, 06:45 PM
  6. Calculate modified average based on criteria from other column
    By excelforum123 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-18-2011, 12:04 PM
  7. calculate average in a column based on criteria in another column
    By sharon t in forum Excel General
    Replies: 2
    Last Post: 05-12-2006, 01:10 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