+ Reply to Thread
Results 1 to 2 of 2

Basic AVERAGEIF/ whatever you suggest question

  1. #1
    Registered User
    Join Date
    11-08-2016
    Location
    UK
    MS-Off Ver
    windows 10
    Posts
    5

    Basic AVERAGEIF/ whatever you suggest question

    Hi guys

    I regularly sort through data such as that below. LEt me put it into context for you. 1, 2 and 3 are products. Within 1, 2 and 3 are 4 variants (colour variants maybe). Now, the second column is the price of each variant. I want all the prices to be the same for the same product. I want a way to see immediately that theres a variation in price within the 4 lines of product 1, 2 or 3 etc.

    Right now I use a subtotal table pasted into a backsheet. It's dreadful and I'm sure averageif would work if I knew how to make it work!

    1 20
    1 20
    1 20
    1 21
    2 15
    2 15
    2 15
    2 16
    3 8
    3 8
    3 8
    3 8

    I was thinking along the lines of an equation that averages just the 4 cells where "1" is in A1:A10000 or similar.

    Any help much appreciated

    Many thanks.

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,925

    Re: Basic AVERAGEIF/ whatever you suggest question

    This can be solved with COUNTIFS. Count the number of prices for the product that are different than the price shown on the row.
    Attached Files Attached Files
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Very Basic Question, I Think.
    By TBarrnes in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-28-2013, 04:57 AM
  2. Averageif Function Question
    By Peeekay in forum Excel General
    Replies: 1
    Last Post: 01-25-2012, 09:26 PM
  3. simple averageif question
    By tannerbabb in forum Excel General
    Replies: 4
    Last Post: 03-31-2011, 12:54 PM
  4. Criteria question - AverageIF (if you please)
    By djalexr in forum Excel General
    Replies: 3
    Last Post: 01-14-2011, 08:00 AM
  5. Replies: 3
    Last Post: 10-13-2010, 04:55 PM
  6. new to vba- basic question
    By tigertim71 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-04-2008, 04:45 PM
  7. Basic VBA question...
    By mattsvai in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-25-2008, 06:19 AM
  8. Basic question
    By plittle in forum Excel General
    Replies: 1
    Last Post: 05-23-2006, 10:55 AM

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