SUMPRODUCT includes comparison of date ranges in two columns and equating it to a constant

Hi friends
I have weird situation in hand..
I have 3 columns,
A B C
10/25/2012 0:00 10/25/2012 0:00 1 - Urgent
11/5/2012 0:00 11/8/2012 0:00 4 - Medium
10/23/2012 0:00 4 - Medium
10/25/2012 0:00 3 - High
10/25/2012 0:00 4 - Medium

I have this formula to calculate for A = B and it is fine. The result is 1,
=SUMPRODUCT(--(O:O=J:J),--(O:O<>0),--(G:G="1 - Urgent"))

But I cant modify this to find B - A = 8
i.e I tried this,
=SUMPRODUCT(--(O:O="J:J+3"))--(O:O<>0)--(G:G="1 - Urgent") this doesnt work

Please can you help ?

Appreciate it. Thank you

Try

Formula:

=sumproduct(--((O:O-J:J)=8),--(O:O<>0),--(G:G="1 - Urgent"))

Sorry
Had played around with that.

Gets my a #Value error.

But thanks

Can you upload your excel with expected output?

sumproduct.xlsx

Sure. PFA.
TY

Try this formula. I am getting 1 for this in your sheet.

Formula:

=SUMPRODUCT(--((B2:B6-A2:A6)=3),--(B2:B6<>0),--(C2:C6="1 - Urgent"))