Matching multiple criteria case

[paradise2sr]

Hi,

I want to do sumif but multiple criteria matching both vertical data and Horizontal data (both Horizontal & Vertical data is large only sample attached here).After matching it will sum the vertical data as in the format in H4:K10 from the data which is given in A2:K13.


Thanx in advance.

[azumi]

Put in cell I5 :

=SUMIFS(INDEX($C$3:$E$13,,MATCH(I$4,$C$2:$E$2,0)),$A$3:$A$13,$H5)

and copied down and cross

[paradise2sr]

That's awesome.Thanx a lot.

What does (,,) means ? can you explain.

[Larry.LeBlanc@O]

I find this easier. It gives the same result

Please Login or Register  to view this content.

[paradise2sr]

Thanx.Can you let me know what does (--) means.