Can't determine why I'm getting #Value for Sumifs function

I'm trying to calculate total walking distances for users by week when I have daily data.

In row 2, I have the week number and in column A, I have the users. In cells b3:BS10, I have their actual miles.

Named ranges are: DailyWeek (B2:BS2), DailyMiles (B3:BS10), Walkers (A3:A10)

My weeks and walkers are formatted as text and my miles are formatted as number

My formula is this: =SUMIFS($B$3:$BS$10,DailyWeek,"1",A3:A10,"XXX") and I continue to get a #Value error, but I don't understand why if everything is formatted the way it should be. Please help!

My workbook is attached.