SUMPRODUCT Date Range

Try this...

Use cells to hold the date criteria.

A1 = start date
B1 = end date

=SUMIFS(BAR!$K$1:$K$9022,BAR!$A$1:$A$9022,V$2,BAR!$AK$1:$AK$9022,$A58,BAR!$G$1:$G$9022,">="&A1,BAR!$H$1:$H$9022,"<="&B1)

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.

Agree with Tony, especially is this is being used over a large range