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.