Need help with SUMIF formula

[NS4Excel]

I am attempting to write a SUMIFS formula but it wasn't working. So, I thought I'd take each argument at a time so I wrote a simple SUMIF formula. (see attached file). The result is not the SUM of the cells but only the amount in the first cell of the range. I copied and pasted the dates so both date cells are formatted the same. I then hard entered the numbers that I need the formula to sum to ensure a formula in those cells wasn't causing the problem. I still can't get this basic SUMIF formula to work so I can move on and created my formula based on multiple criteria. Any assistance would be greatly appreciated to explain what is wrong.
help.xlsx

[AliGW]

Which cell contains or should contain the formula and what exactly do you expect it to do?

[Ace_XL]

Your ranges are inconsistent. the criteria range covers only 1 row, hence it returns just the first value

Use either of these
=SUMPRODUCT($R$10:$S$13*($R$9:$S$9=W9))
or
=SUM(INDEX($R$10:$S$13,,MATCH(W9,$R$9:$S$9,0)))

[AliGW]

=IF(R9=W9, R10+R11,"")

Seems to work.

[NS4Excel]

Thank you all for the answers. As I said, my ultimate goal is to write one that will match multiple criteria and this is just the starting point. Cell Y9 is the formula I am trying to get to work. It should sum cells R10 and R11 since the dates in R9 and W9 match. I am not interested in getting into an INDEX,MATCH formula as it will get convoluted with all I ultimately want the formula to do. A SUMPRODUCT is an option however I wanted to just use the SUMIFS in the end. Using just an IF formula is not going to work when I get to writing the formula for multiple criteria as you can only use 7 nested IF statements.

[popipipo]

You can use sumproduct with more criteria.

[AliGW]

Using just an IF formula is not going to work when I get to writing the formula for multiple criteria as you can only use 7 nested IF statements.

You can use up to 64 with Excel 2010, actually.

[JJGF]

I am attempting to write a SUMIFS formula but it wasn't working. So, I thought I'd take each argument at a time so I wrote a simple SUMIF formula. (see attached file). The result is not the SUM of the cells but only the amount in the first cell of the range. I copied and pasted the dates so both date cells are formatted the same. I then hard entered the numbers that I need the formula to sum to ensure a formula in those cells wasn't causing the problem. I still can't get this basic SUMIF formula to work so I can move on and created my formula based on multiple criteria. Any assistance would be greatly appreciated to explain what is wrong.
Attachment 313672

Are you able to run the dates down its own column?

[azumi]

Maybe this should do it, using SUM and IF

=SUM(IF(R9:S9=W9,R10:S11))

Array Formula