Hi all
This is the formula I made in excel 2010:
Formula: copy to clipboard 
COUNTIFS($T$7:$T$10421,AH8,$U$7:$U$10421,IF($F$4="","*",$F$4),$V$7:$V$10421,IF($G$4="","*",$G$4))


The bolded parts I added so that if the cells for criteria2 and criteria 3 are blank, a "*" is inserted, making all entries match this criteria.
If I was to convert this to the SUMPRODUCT function so that the spreadsheet would work in excel 2003, it wouldn't work, because the wildcard does not work in this function.

Does anyone know of a formula I can use in Excel 2003 that would work?

Thanks in advance!