Hello,
Can you guys help me with below requirement.
I have a below formula which i need to put it a column by searching for a date in Row3. that date should be given as user input.
let us say user gives the data as 10/24/2020 then the code needs look for the date in row 3 and if it is found in row3 of column "G" then it has to apply the formula from G4 to the last row of data as per column "A". consider my sheet name as sheet1.
=IF($A4 = ""Grand Total"",SUM('Source Data'!$M:$M),IF($B4="""",SUMIFS('Source Data'!$M:$M,'Source Data'!$T:$T,'View 1 Week on Week Trend - Un'!$A4),SUMIFS('Source Data'!$M:$M,'Source Data'!$T:$T,'View 1 Week on Week Trend - Un'!$A4,'Source Data'!$U:$U,'View 1 Week on Week Trend - Un'!$B4)))"
Can you guys help me with below requirement.
I have a below formula which i need to put it a column by searching for a date in Row3. that date should be given as user input.
let us say user gives the data as 10/24/2020 then the code needs look for the date in row 3 and if it is found in row3 of column "G" then it has to apply the formula from G4 to the last row of data as per column "A". consider my sheet name as sheet1.
=IF($A4 = ""Grand Total"",SUM('Source Data'!$M:$M),IF($B4="""",SUMIFS('Source Data'!$M:$M,'Source Data'!$T:$T,'View 1 Week on Week Trend - Un'!$A4),SUMIFS('Source Data'!$M:$M,'Source Data'!$T:$T,'View 1 Week on Week Trend - Un'!$A4,'Source Data'!$U:$U,'View 1 Week on Week Trend - Un'!$B4)))"
