Sumif formula with 2 match conditions

[vijayca]

Hi All,

I want result using sumif formula with 2 match conditions or with alternate function to get the desire result.

I have attached file with 2 sheets inside... in first (sheet name Example) is given example and other is source data (sheet name TB)

Request to help to resolve. For any query, pls. revert on.

Thanks in Advance.

Regards,

Vijay

[TMS]

Use SUMIFS, not SUMIF.


Regards, TMS

[Khalidngo]

Hi Vijay,

SUMIF(s) does not work with mixed arrays, I have used:
=SUMPRODUCT((TB!$D$3:$O$3=$C$12)*(TB!$C$5:$C$10=$B14)*(TB!$D$4:$O$4=C$13)*(TB!$D$5:$O$10))

and DO NOT USE MERGE CELL, I have un-merged and typed company names so they can be matched.

See if this is okay

Blessing

[JohnTopley]

Unmerge your "Company" cells

=SUMPRODUCT((TB!$D$5:$O$10)*(TB!$D$4:$O$4=Example!C$13)*(TB!$C$5:$C$10=Example!$B14)*(TB!$D$3:$O$3=Example!C$12))

[vijayca]

Hi Khalidngo,

Its working. Thanks for your valuable help.

Regards,

Vijay