PDA

View Full Version : Solved: Substitute Sheet Name in SUM if Function



anandbohra
08-17-2007, 10:36 PM
Hi all

I have a simple formula
=SUMIF(ABB!B:B,"Buy",ABB!F:F)
Here Sheet Name is ABB

anybody has idea as to how to substitute this sheet name with value already there in some cell

e.g.
Cell A1 Contents Maruti
then the above formula should automatically gives me results for Maruti
(=sumif(Maruti!B:B,"Buy",Maruti!F:F)

Shazam
08-17-2007, 11:36 PM
=SUMIF(INDIRECT("'"&A1&"'!$B$2:$B$20"),"Buy",INDIRECT("'"&A1&"'!$F$2:$F$20"))

anandbohra
08-18-2007, 12:14 AM
Thank you Very much

:rotlaugh: