Sumif

[Weasel]

Hey,

I have an excel worksheet with numbers going across row 4 starting in column B. As an example B4 = 163001, C4 = 163002, D4 = 163006, E5 = 163301, etc... These numbers represent locations.

In column A I have dates going down the row's starting in row 5. As an example A5 = 1/1/12, A6 = 1/2/12, A7 = 1/3/12, etc... These number represent dates for each location

From cells B5 through L95 there are values.

I'm looking for a function that will allow me to sum all the values for a location based off of a date range. As an example, a function that would give me the sum of all values for the location 163006 for the date range of 1/1/12 through 2/15/12.

Any help would be greatly appreciated. Thanks.

[daddylonglegs]

Hello Weasel, try using SUMPRODUCT like this

=SUMPRODUCT((A$5:A$95>=N2)*(A$5:A$95<=O2)*(B$4:L$4=P2),B$5:L$95)

assuming N2 has the start date, O2 the end date and P2 the specific location

[Weasel]

Thank you so much for your help.