Why Excel formula is not completely displays in Y!Answer?

Favorite Answer

hi siti
ive seen some of your VBA answers...good stuff
you need to put spaces in your formula

=SUMPRODUCT(SUMIF(INDIRECT("'"&S1:S100&"'!$B$1:$B$10"),"search string",INDIRECT("'"&S1:S100&"'!$A$1:$A$10")))

without spaces
but put spaces in and it turns into this

=SUMPRODUCT(SUMIF( INDIRECT("'"&S1:S100&"'!$B$1:$B$10"), "search string",INDIRECT("'"& S1:S100&"'!$A$1:$A$10")))

i put a space after the ( or a , or an & sign and excel will know to ignore the spaces.

i think its yahoos way of cutting down long linbks to webpages...and it has a side effect of cutting longs strings of excel formulas down to ...

http://answers.yahoo.com/question/index;_ylt=ArE.PIZ3mNx.bQdhhnbSQ5jty6IX;_ylv=3?qid=20090711152806AAixboi...Show more