I have been trying to convert the following countifs formula to 2003 and have tried all possibilities listed on this website from what I can, Specifically using sumproduct instead.

Can any one help, I am at a complete loss!!!!!

The formual is written on an overview sheet, pulling out information from a shreadsheet detailing lists of company credits.

Essentially listing how many credits an account has had, between specific dates and for a specific reason.

= COUNTIFS(Credits!$B$2:$B$257,">="&$C$4,Credits!$B$2:$B$257,"<="&$E$4,Credits!$D$2:$D$257,B73,Credits!$H$2:$H$257,$E$26)

,">="&$C$4 - refers to a date criteria
,"<="&$E$4 - refers to a date criteria

B73 - refers to along account name

$E$26 - refers to complaint type

Please anyone let me know your thoughts?