Hi all ,
I need a help from the below code/formula:
"=SUMIF(Sheet1!A14:A103, "=Total",Sheet1!M14:M103)". I need values 14 and 103 replaced by a variable.
when i run a particular macro i will get the variable values say w1_endrow,w1_startrow so that the formula gets updated. i tried these below codes.But none worked .

=SUMIF(Sheet1!(INDIRECT("A"&w1_startrow:"A"&w1_endrow)), "=Total",Sheet1!(INDIRECT("M"&w1_startrow:"M"&w1_endrow)))
=SUMIF(INDIRECT(Sheet1!("A"&w1_startrow:"A"&w1_endrow)), "=Total",INDIRECT(Sheet1!("M"&w1_startrow:"M"&w1_endrow)))
=SUMIF(Sheet1!("A"&w1_startrow:"A"&w1_endrow), "=Total",Sheet1!("M"&w1_startrow:"M"&w1_endrow))
=SUMIF(Sheet1!(A&w1_startrow:A&w1_endrow), "=Total",Sheet1!(M&w1_startrow:M&w1_endrow))Pls anyone help me in this.

Thanks