Help with Sumifs

[JP9797]

I'm trying to create a file that will show me how many people requested vacations on a certain day of a certain month. I plan on using data validation so that just by selecting the month and day it will tell me how many people are on vacation on that specific day without having to go and "manually" check the calendar. But the problem is that my sumifs uses vertical and horizontal criteria and from what Ive read excel doesnt like that. Is there a way to do it? The formula Im using is =SUMIFS(D3:O33,C3:C33,A5,D2:O2,A4) but it keeps returning VALUE! as you can see in the pic

 

[kweaver]

What are you expecting in A6? 1? Does A5 indicate how many days you are looking at?

 

[JP9797]

I want A6 to tell me how many people are on vacation on January 1st, so yes I expect 1. As for the A5 Its the day that I want to see, so If I change A5 to 3 I want it to tell me how many people are on vacation on January 3rd.

 

[kweaver]

Maybe this?

=INDEX(D3:O33,A5,MATCH(A4,D2:O2,0))

 

[JP9797]

Exactly what I was looking for TYVM. Now that I think about it I have no idea why I decided to use sumifs.