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