using sumproduct in a range of text fields?
 

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.

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

"Basil" wrote:

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.