First, Thank you for helping / looking.
I'm trying to count the number of cells that match two criteria and have
looked through many many responses and tried several of the suggestions but
no luck.
I have this formula:
SUMPRODUCT(--('[Spares Quotes List V22
26Apr2007.xls]All'!$A$2:$A$5000=$A26),--(YEAR(DATEVALUE('[Spares Quotes List
V22 26Apr2007.xls]All'!$M$2:$M$5000))=1900))

What it is $A$2:$A$5000=$A26 is text and $M$2:$M$5000))=1900 is a date.
1900 needs to be there because I place a 0 were I don't need to look at this
cell but I need to count it so the totals work out. Can I count using text
for one criteria and a date for the other?

Thanks in advance for your help.
Joe