Hey Guys,

I'm currently compiling a spreadsheet which checks a number of condition on
seperate worksheets but also other workbooks. The problem i've got at the
moment is that the formula ive put in is accepted but gives an incorrect
value.

I'm using the formula :

=SUMPRODUCT(--('[Branding log 07.xls]Helmet New -
Mod'!$A$2:$A$10009="40"),--('[Branding log 07.xls]Helmet New -
Mod'!$F$2:$F$10009="New"))

This needs to check in a seperate workbook whether the value is "40" in
column A and "New" in column F.

the problem is its giving me a figure of 0 even though i know for a fact
there are 5 entries which meet that criteria.

Heeeelp !! :) :)

Michael -