Results 1 to 5 of 5

Which formula to use with multiple criterias?

Threaded View

  1. #1
    Registered User
    Join Date
    07-24-2017
    Location
    Korea
    MS-Off Ver
    MS 2010, 2016
    Posts
    7

    Which formula to use with multiple criterias?

    I have been trying to use AVERAGEIFS formula to find a range of prices for my data but have failed to solve it.
    The data is as follows
    ExcelFormula.png

    I want to find out the average prices of 32 inch (In the actual sheet there are multiple sizes e.g 30,34,40, etc) that is GM Type but including ones that are labeled GM 2K and GM 4K. Which formula should be used? I am a beginner in Excel FYI.
    Last edited by sbea114; 07-24-2017 at 10:57 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula to get an value from multiple criterias
    By Vikramchetan in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-19-2017, 10:46 AM
  2. [SOLVED] Formula to Sumproduct with multiple criterias
    By kunjanee in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-17-2016, 01:56 PM
  3. IF formula or multiple criterias
    By Doongchen in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-08-2016, 10:32 PM
  4. [SOLVED] Simplify this formula for summing a row with multiple criterias
    By phatal in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 09-17-2015, 04:33 AM
  5. multiple criterias in SUMIF formula
    By aysrun in forum Excel General
    Replies: 8
    Last Post: 07-29-2009, 02:40 AM
  6. making a formula with multiple criterias
    By abrunstad in forum Excel General
    Replies: 4
    Last Post: 03-30-2009, 05:23 PM
  7. Creation formula with multiple criterias
    By s-vadik in forum Excel General
    Replies: 13
    Last Post: 10-24-2008, 02:35 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1