Results 1 to 2 of 2

Vba to get average based on two criteria on the same column

Threaded View

siobeh Vba to get average based on... 07-09-2015, 03:14 PM
GeneralDisarray Re: Vba to get average based... 07-09-2015, 03:17 PM
  1. #1
    Forum Contributor
    Join Date
    04-23-2013
    Location
    India
    MS-Off Ver
    Excel 2003 and 2007
    Posts
    227

    Vba to get average based on two criteria on the same column

    Hello,

    I just want to get the average of one of my column (Column J) based on two criteria on the same column (Column BA).

    The two criteria are:
    
    Column BA is not equal to VANILLA VOIP & VoIP Enterprise AND Column B is equal to CSM-1
    I've used the below formula
    Column Q = Score
    
    =AVERAGEIFS(Q:Q,BA:BA,"CSM-1",J:J,"<>VANILLA VOIP",J:J,"<>VoIP Enterprise")
    Last edited by siobeh; 07-09-2015 at 03:29 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Average one column based on multiple criteria
    By smartbuyer in forum Excel General
    Replies: 7
    Last Post: 03-13-2015, 04:37 AM
  2. [SOLVED] Average, max and min based on 3 criteria
    By VBADUD in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-06-2013, 11:07 PM
  3. [SOLVED] Average based on a criteria
    By caabdul in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-30-2012, 12:14 AM
  4. 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
  5. 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1