SUMPRODUCT Date Range

Hi -

A sample spreadsheet would really help get to an answer for you. If you could post some sample data with a couple examples of your intended outcome that would be REALLY helpful. Are you comparing to a single cell in column G and Column H or are you comparing the entire column of dates of both G and H to Columns A and AK?

Based on the information you have given, assuming a single cell in G and H, I would say your formula would look something like:

=SUMPRODUCT((BAR!$A$1:$A$9022>=G?)*(BAR!$A$1:$A$9022<=H?)*(BAR!$AK$1:$AK$9022>=G?)*(BAR!$AK$1:$AK$9022<=H?),BAR!$K$1:$K$9022)

As a side note there are a couple redundancies in your formula that I have removed from the above solution. First, I don't understand why you need SUM of the SUMPRODUCT. It will work, but it doesn't really do anything. Second, since you are multiplying your two conditions (Column A = V2 times Column AK = A58) you don't need the unary operator (the two dashes --). Doesn't hurt anything, but it's redundant. Again, just some picky stuff.

Hope this helps.

This operation can be done with the more efficient SUMIFS function.