Sumproduct with 2 conditions across 2 workbooks
 

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 -

Sumproduct with 2 conditions across 2 workbooks
 

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)

"Karma2400" wrote in message
...
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 -

Sumproduct with 2 conditions across 2 workbooks
 

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

"Bob Phillips" wrote:

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)

"Karma2400" wrote in message
...
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 -