Thread
:
Formula changes as new data is entered...
View Single Post
#
2
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
Formula changes as new data is entered...
You can use a hidden row as the first row and start your sum formula after.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"SMOKN_ENG_MOM" wrote in message
...
I have a master sheet calculating for certain criteria on another sheet.
As new data is added to the "other sheet" (it is being inserted each time
at
row 3)the formula on the master sheet changes to start array at row 4...
next
time row 5... etc. So it does not include new data added in the formula.
How can i lock this down to not move with each data entry?
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett