I have entered a formula into excel which I have used in the past successfully. However, once I press return or click on another cell, the formula automatically updates the range of cells incorrectly.
For example, In cell D2 I entered:
=SUMIF($A$1:$XFD$1,"*q_yourweight_6mths.fp_pounds *",A2:XFD2)
and it changes to this:
=SUMIF($1:$1,"*q_yourweight_6mths.fp_pounds *",2:2)
Could anybody help me stop it doing this? Thank you.
For example, In cell D2 I entered:
=SUMIF($A$1:$XFD$1,"*q_yourweight_6mths.fp_pounds *",A2:XFD2)
and it changes to this:
=SUMIF($1:$1,"*q_yourweight_6mths.fp_pounds *",2:2)
Could anybody help me stop it doing this? Thank you.