Trying to do Sumif using the worksheet no

[mushmoom]

Hi there

I dont know if i will be able to explain this but here I go.

I am trying to to a sumif to get the result in a different sheet the first thing i need to do is to find sheetnames from workbook then once the workbookname is fund then set the range and the usual,

here I try to explian again in

Where (workbook(sheetname)=A1,sumif(workbook!sheetA1!A1:A30,D1,Workbook!sheetA1!D1:D30)

and i need this to work for to workbook is it possiable.

thanks

I hope i have explained it .

 

[DonkeyOte]

take a look at the INDIRECT function in Help.

INDIRECT essentially evaluates the string within ()

ie

=INDIRECT("A1") translates as =A1
=INDIRECT("Sheet1!A1") translates as =Sheet1!A1

If say cell A1 = "SUM(Sheet1!B10:D10)"

=INDIRECT(A1) would translate as =SUM(Sheet1!B10:D10)

so you just need to construct a variable text string where sheet name is a variable etc...

 

[mushmoom]

see column A got the sheetname what i need to do the get the data from 2 workbooks which contain sheet with the same name as in column A