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