• 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.

Regading Array Handling

MBS

New Member
Hi all,
Please let me know if below sumif construction is correct or not. I mean, IF statement in SUM_Range field will generate an array. Will it be evaluated by SUMIF, noting that the height of the array is same.
=SUMIF($G$3:$G$341,$D346,IF($F$4:$F$341=E$345,$C$3:$C$341))
 
Top