SUMPRODUCT be/wn 2 dates in a cell reference Excel 2003

[QIBusinessGroup]

Hello all,

I am having trouble converting my Excel 2007 formula to Excel 2003.

What I am trying to do is have excel count the number of occurance in one cell based upon dates in another cell.
Here is the formula in 2007 (which works perfectly)
=SUMPRODUCT(--(CaseTracker!$K:$K="Follow-Up"),--(CaseTracker!$N:$N>=$N8),--(CaseTracker!$N:$N<=$O8))

However when I emailed it to a co-worker who has 2003 i got #num errors.
I attempted to modify it in excel 2003 with this formula
=COUNTIF(CaseTracker!$K:$K,"Follow-Up")-COUNTIF(CaseTracker!$E:$E,">="&$N7)-COUNTIF(CaseTracker!$E:$E,">="&$O7)

and
=SUMPRODUCT(--(CaseTracker!N8:N1500<=1/1/2011),--(CaseTracker!N8:N1500>=1/7/2011),--(CaseTracker!K8:K1500="Follow-Up"))

however both formulas give me the wrong number. Can anyone tell me what I am doing wrong.

P.s. Column N and O contains dates. N is start date and O is end date.
if you need me to provide additional info please email me at QIBusinessGroup@Gmail.com

Thank you in advance for any assistance it will be greatly appriciated and received.

 

[VoG]

You cannot use whole column references in Excel 2003 (and it is ill-advised in later versions). Try like this

=SUMPRODUCT(--(CaseTracker!$K1:$K1000="Follow-Up"),--(CaseTracker!$N1:$N1000>=$N8),--(CaseTracker!$N1:$N1000<=$O8))

 

[QIBusinessGroup]

you cannot use whole column references in excel 2003 (and it is ill-advised in later versions). Try like this

=sumproduct(--(casetracker!$k1:$k1000="follow-up"),--(casetracker!$n1:$n1000>=$n8),--(casetracker!$n1:$n1000<=$o8))

iT works now thank you very much. You have truly saved me hours of time.

 

[VoG]

Did you try the SUMPRODUCT formula that I posted?