using sumproduct in a range of text fields?

B

Basil

Hi, I have a question using sumproduct identifying a range of text in
multiple columns and calculating their values in another column. How do you
use the formula- =SUMPRODUCT(('[2004 GL download master.xls]2004 GL
'!$C$2:$C$189="'720'")*('[2004 GL download master.xls]2004 GL
'!$D$2:$D$189="'50'")*'[2004 GL download master.xls]2004 GL
'!G$2:G$189)+SUMPRODUCT(('[2004 GL download master.xls]2004 GL
'!$C$2:$C$189="'725'")*('[2004 GL download master.xls]2004 GL
'!$D$2:$D$189="'00'")*'[2004 GL download master.xls]2004 GL '!G$2:G$189)
without typing all of the text values and using ranges?
Thanks.
 
F

Frank Kabel

Hi
So you want for example replace ="'720'" with a range/cell reference?. Why
not simüply replace it. e.g.
....=A2
 
Top