Sumifs??
Results 1 to 2 of 2

Thread: Sumifs??
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Mar 2013
    Posts
    16
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Sumifs??

    Trying to get an average from two disctinct arrays when two conditions exist

    For instance

    =IF(SUM(WP6:XY6,YD6:YL6)>0,AVERAGE(WP6:XY6,YD6:YL6),"")

    Which is fine, but I would like it to work when WP4:XY4 AND YD4:YL4 = to either CC or AB

    Can someone please help out??

    I've been banging my head on this bloody desk for the past three hours to no avail

    Thx

  2. #2
    MrExcel MVP
    Join Date
    Aug 2010
    Location
    Rio de Janeiro BRAZIL
    Posts
    16,239
    Post Thanks / Like
    Mentioned
    19 Post(s)
    Tagged
    8 Thread(s)

    Default Re: Sumifs??

    See if this example helps

    A
    B
    C
    D
    E
    F
    G
    H
    I
    J
    K
    L
    M
    N
    O
    1
    Result
    2
    7
    3
    4
    AB
    AC
    CC
    CB
    CC
    CC
    AB
    AC
    CC
    CB
    CB
    CC
    5
    6
    3
    10
    8
    5
    4
    3
    10
    2
    12
    10
    8
    9
    7


    Formula in B2
    =IF(SUM(B6:G6,I6:N6)>0,SUM(SUMIF(B4:G4,{"AB";"CC"},B6:G6),SUMIF(I4:N4,{"AB";"CC"},I6:N6))/SUM(COUNTIF(B4:G4,{"AB";"CC"}),COUNTIF(I4:N4,{"AB";"CC"})),"")

    M.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •