i need to use variable in formula

“find” variable contain the column value as 49

 

now i need to use this variable in below formula,

the “AW” column should be replace by “find” variable. please help 

 

    Worksheets(“Overall”).Cells(2, Find).Formula = “=IF(SUMIFS(‘Invoiced Hours’!$G:$G,’Invoiced Hours’!$I:$I,Overall!$A2,’Invoiced Hours’!$A:$A,Overall!” & Find & “$1)=0,SUMIFS(Weekly!$G:$G,Weekly!$I:$I,Overall!$A2,Weekly!$A:$A,Overall!” & Find & “$1),SUMIFS(‘Invoiced Hours’!$G:$G,’Invoiced Hours’!$I:$I,Overall!$A2,’Invoiced Hours’!$A:$A,Overall!” & Find & “$1))”

By: azar

Leave a Reply

Your email address will not be published. Required fields are marked *