Constant value causing #value! error????

I have a sumifs formula that appears to be correct in every way, I have successfully used them in other worksheets but this one is stumping me.
The formula in S6 is meant to be copied across and down thru Y57.
I inserted row 5 with numbers vs. location name to attempt to correct the error but no luck.
It may be something simple I'm missing, can anyone find the cause of the error in the attached file?
Thanks,
#VALUE! ERROR FIX NEEDED 5-29-14.xlsm

You can't do that with Sumifs.
The ranges must be of equal dimensions.
So you can't do one criteria in a column C6:C92
And a 2nd criteria in a row E5:K5


Try this in S6 filled right/down

=SUMIF($D$6:$D$92,$R6,INDEX($E$6:$K$92,0,MATCH(S$4,$E$4:$K$4,0)))

Or if the headers in S4:Y4 are the same as the headers in E4:K4 (and in the same order left to right)
Then it's just
=SUMIF($D$6:$D$92,$R6,E$6:E$92)

The Index-Match formula worked as well as the other one, thanks JonMo1 for that. I knew it might hinge around my ranges, just didn't stumble on the solution.
Learn something every day.

Glad to help, thanks for the feedback.