Sumif for a Range (Backwards from most Threads I have read)

[farewinners]

I have attached my excel file. I am trying to do the equivalent of a sumif. I have tried a sum products and a sum(if as an array and neither have worked for me. I have looked up other threads and all of them want to sum multiple columns if one column is true. I want to sum 1 column is any of the value in the same row of a multiple column range are true. I have a bunch of dates in the worksheet dates and want to sum the minutes in column A. Worksheet Minutes per week is where I want this information to total. If there is a date in the dates worksheet the is between the start date and then end date in rows 1 and 2 i want it to sum the total minutes in Column A of worksheet Dates.
Thank you in Advance

[judgeh59]

I guess I can't see the attached file....have you tried a SUMIFS function?

[Jonmo1]

I don't see an attachment either.

But it sounds like you'll need sumproduct to work with ranges of different dimentions..

something like

=SUMPRODUCT((multicolumnrange=criteria)*(singlecolumnrangetosum))

[farewinners]

Here is the file

[Jonmo1]

In B4 and filled right

=SUMPRODUCT((Dates!$B$2:$T$291>=B2)*(Dates!$B$2:$T$291<=B3)*Dates!$A$2:$A$291)

[farewinners]

Thank you so much for your help. It works perfectly. Do you mind explaining how it works? Thank you

[Jonmo1]

It creates an array of values to be summed
Created by the True/False results multiplied by the values in column A

(DateinB-T>=B2, TrueorFalse)*(DateinB-T<=B3, TrueorFalse)*(valueinA)

True = 1
False= 0

So only if both are True will it be added
If either is false, it will be a 0
0*0*180 = 0
0*1*180 = 0
1*0*180 = 0
1*1*180 = 180

[farewinners]

Thank you for the explanation. It makes a lot more sense to me now. Thank you