want to create a formula using variable

[mrinal saha]

Hi folks,

Want to create a formula to fetch data from other sheet.

I am using sumif formula. ideal formula would be
=SUMIF('A06'!H:H,"hold",'A06'!M:M) but i am trying through variable to make it more dynamic.

yy = Cells(Range("a" & lr + 12).Row, y).Value
xx = Cells(i, 1).Value

value of yy = A06
value of xx = hold

and this is something i am trying but not working

Cells(i, y).Formula = "=sumif('yy' & ""!H:H"",xx,'yy' & ""!M:M"")"

please show me how to do it correctly?

thnxxx,
Mrinal

 

[Jonmo1]

Try

Cells(i, y).Formula = "=SUMIF('" & yy & "'!H:H,""" & xx & """,'" & yy & "'!M:M)"

 

[mrinal saha]

Yes this works... Thanks a lot