• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Sumifs in merged cells with criteria

Villalobos

Active Member
Hello,

I would have a question regarding the "sumifs" of merged cells, it is inspired by a formula challenge in 2013. Here is the path to the thread: https://chandoo.org/forum/threads/formula-challenge-021-sumif-in-merged-cells.11927/

The question: how to sum the values with criteria?
The criteria: if one of item is repeated in range X (it has always the same value in range V) then the formula should take into account only one time its value when the sum is calculated for the item in range D.

You can find attached the sample file with the desired manual results.

Non-array is preferred.

Thank you for any solution you can provide.
 

Attachments

  • sample.xlsx
    11 KB · Views: 5
Another formula option without helper

In F6, array ("Ctrl"+"Shift"+"Enter") formula copied down :

=SUM(IFERROR((LOOKUP(ROW(D),ROW(D)/(D<>""),D)=E6)*V*(MATCH(X,X,0)=(ROW(X)-1)),0))

79364
 

Attachments

  • SumifInMergeCells (BY).xlsx
    12.2 KB · Views: 8
Back
Top