Sumproduct with 2 conditions across 2 workbooks

  • Thread starter Thread starter Guest
  • Start date Start date
G

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 -
 
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)
 
Oy your right .. so simple but i couldnt see it, thats what stress does for
ya :) ty ! :)

Bob Phillips said:
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 said:
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 -
Click to expand...
Click to expand...
 
Back
Top