Use SumIF based on date in adjacent cell

HTML Code: 

Lets say I have the above table. I am trying to find out payment dates which are one month (30 days) later than the invoice date. I basically want to operate on row by row basis. In the final column I wan to see the sum of all payments that were made late.

I have tried this logic

=SUMIF(C2:C7,">4/1/2012",A2:A7)

which works for a fixed value. But I want to match it to invoice date next to it.

I tried that already it basically compares to fixed cell D2 which is not desired.

Originally Posted by rocketscience

Ok this did not work as you said it but when I entered it Shift+Ctrl+Enter, it worked out of the blue. I guess you have to make it an array.

I need a different solution though because I am implementing this programatically, probably using SUMIFS

Thanks for the help

correction

This did not work. It still compares the dates to one cell that D2 even with the array formula.

Originally Posted by daddylonglegs

OK, perhaps I missed your intent, If you want to check if payment date (C2:C7) is more than 30 days after the invoice date (D2:D7) and if so add the amounts from A2:A7 for each row where the condition is met then try SUMPRODUCT like this

=SUMPRODUCT((C2:C7-D2:D7>30)+0,A2:A7)

In your example that looks like rows 2 and 6 would qualify so that formula will give the result 25+45 = 70, is that the expected result? If not can you explain what it should be?

Yes this did it. Thanks!

Can you please explain what is the meaning of +0 in the expression. With out it, it does not work. Displays 0 value.

=SUMPRODUCT((C2:C7-D2:D7>30)+0,A2:A7)