Hello,

I'm trying to sum a number of values depending on if three different
criterias are met. Formula at the moment (one sheet):

=SUMPRODUCT((YEAR('09'!$N$7:$N$500)=YEAR($C$2))*(M ONTH('09'!$N$7:$N$500)=MONTH($C$2))*('09'!$E$7:$E$ 500=A28)*'09'!$P$7:$P$500)

Now let's say that I'd like to sum values not just from year '09' but from
00-09, how do I do that?

I've looked around at other similiar questions but I still can't solve the
problem...

Thanks in advance!

//JB