Multiple Criteria SUMIF

[Smigles]

Hi guys.
I've been hunting hi and low for the answer on this but it doesn't appear to be on here, or I can't fully understand how to use it. So if it appears to be duplication, I apologise.

Here's my data...

So. I want to be able to change A1 and A2 to provide the criteria.
e.g. I want to select "day" as the criteria, I type it into A1, and then want to return results for "Monday"so type this into A2, the solution is 1. Similarly, I could type "year" into A1, and "10" into A2 to get the solution 4. etc.
Now I already have that cracked with a nested IF function. However, when I'm returning the solution I want to only sum negative numbers in the "Results" range.
Any way of doing this?

 

[barry houdini]

Hello Smigles, welcome to MrExcel,

Which version of excel are you using? In Excel 2007 and later versions you can use SUMIFS, i.e.

=SUMIFS(C5:C14,C5:C14,"<0",IF(A1="DAY",A5:A14,B5:B14),A2)

in earlier versions try SUMPRODUCT like this

=SUMPRODUCT(C5:C14,(C5:C14<0)*(IF(A1="DAY",A5:A14,B5:B14)=A2))

 

[Smigles]

Thanks so much Barry!
Had to use the SUMPRODUCT, as my version is too early.