Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Why Excel formula is not completely displays in Y!Answer?
in Questions also in Answers
for example:
=B1-IF(A1<TEXT("7:00","[h]:mm"),TEXT("…
1 Answer
- expletive_xomLv 71 decade agoFavorite 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 ...
