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)
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)