Averageifs with Multiple Criteria in Same Range



I’m a bit stuck with the functions formula where I want to use multiple criteria. I’ll use the data set below as a mock example: –



Product Company Cost
X A 200
Y B 300
X C 400
Y C 100
Y B 350
X A 100
X C 250
Y C 600
Y B 150
X B 375
X A 450
Y B 110


I’m want to use the averageifs function to calculate the average “cost” for “product” X but only with both “company” “A” AND “B”.


I seem to getting an error everytime I use the same range column.


Any help would be appreciated.

By: Sham

22 thoughts on “Averageifs with Multiple Criteria in Same Range

  1. sling tv

    Hi, I do think this is a great website. I stumbledupon it 😉 I am going to come back once again since I
    book marked it. Money and freedom is the best way to change, may you be rich and
    continue to guide others.

  2. sling tv

    Link exchange is nothing else but it is just placing the other person’s weblog link on your page at appropriate place and other person will also do same in support of you.

  3. sling tv

    I was suggested this web site by my cousin. I am not sure whether this post is written by him as no
    one else know such detailed about my trouble. You’re amazing!

  4. how to get help in windows 10

    Thank you for some other informative blog. The place else may
    just I am getting that kind of info written in such a perfect approach?
    I’ve a challenge that I’m simply now working on, and I have been on the glance
    out for such info.

  5. ps4 games

    I delight in, lead to I found exactly what I was looking
    for. You’ve ended my four day lengthy hunt! God Bless you man. Have a
    great day. Bye

  6. quest bars cheap

    Hi! I know this is kind of off topic but I was wondering if you knew where I
    could locate a captcha plugin for my comment form? I’m using the same blog platform as yours and I’m
    having difficulty finding one? Thanks a lot!

  7. ps4 games

    Everything is very open with a really clear clarification of
    the challenges. It was truly informative.
    Your site is very helpful. Many thanks for sharing!

  8. coconut oil why

    My spouse and I stumbled over here coming from
    a different web address and thought I should check things out.
    I like what I see so now i’m following you.
    Look forward to checking out your web page again.

  9. http://tinyurl.com

    I think this is one of the most significant info for me.

    And i’m glad reading your article. But want to remark on some general things, The website style
    is great, the articles is really nice : D. Good job, cheers

Comments are closed.