How do I change formula in a row when the column had another formula already?
How do I change formula in a row when the column had another formula (from convert formula for the column)? I tried to change formula for just one row but the formula changed for the whole column. How can I restrict formula change to just the row I needed.
See sample file attached. Colum H is the total of Colum E, F ,G. But for row 4 to 10 , I would like to average the number in column E,F, G. I tried change formula in row 4 but the formula for entire column changed??
Help Article Resources
Check out the Formula Handbook template!