Sumproduct with 2 conditions across 2 workbooks

[Guest]

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 -

 

[Bob Phillips]

Probably testing for a number

=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"))


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Guest]

Oy your right .. so simple but i couldnt see it, thats what stress does for
ya ty !

Probably testing for a number

=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"))


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

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 -