The limitation of SUMIFS?

Hi all,

I have a question on multiple criteria for SUMIFS:

The criteria of the attached excel are:

If
a) it is Project 2
b) it is under "n"

the sum it, and the result is 7 then.

However, SUMIFS criteria should be on either row-directional or column directional, I guess it cannot be mixed. So in order to achieve this, should I use SUMIFS or anything else?

Thanks

Nicky


Thanks.