Can an “If statement” be setup to return a numerical value from a cell but not the formula

This spreadsheet has rows with just numerical data in the cells. Many of the cells are blank. Sometimes the data in one cell is identical to the cell immediately above it. These are called repeaters. At the end of each row there is a cell where I manually input the number of repeaters in that row. The next cell after that cell calculates the average of the rows that have repeaters in them from the top of the column to the current cell. I am not calculating the number of repeaters, just the percentage of rows that have repeaters in them. I use this formula for that;
IF(BQ976>0,COUNT(BQ$976: BQ976)/(COUNT(BQ$976: BQ976)+COUNTBLANK(BQ$976: BQ976)),"")
When I drag this formula down the column, BQ976:BQ1009, it indexes automatically so it calculates the percentage for each row from the top of this column to the bottom as the data is input. The last cell in that column, BQ1010, calculates the average of the averages from BQ976 to BQ1009. It is this cell, BQ1010, which is giving me problems.
The data rows are 61 columns wide, G976:BO976. I want to automatically mirror a parallel row from BR976 to DZ976, but instead of entering the data from G976:BO976, I want to enter the average of the averages from BQ1010 in each mirrored cell. So if BQ1010 has a displayed value of 0.71 and G976 has numerical data in it, then I want BR976 to have the value 0.71 not the formula from BQ1010. I have been using this formula, IF(G976>0,$BR$1010,"") by placing it in BR976 and dragging it across to DZ976. The G976 indexes so any cell in G976:BO976 that has data in it gets 0.71 in its mirror in BR976:DZ976. That is what I want. The problem is that when I enter data in the next row G977:BO977, BQ1010 changes and the 0.71 changes in the first row because my formula enters the formula from BQ1010. I need the 0.71 to remain fixed in the first row. How do I do that?

deleted post

This is going to take me awhile. I just need to upload one page out of a workbook that has many pages. The whole book is almost 8 megs. I just tried to copy and paste the single page into a new workbook but it lost all its formatting so I will fix that and try again.

Here it is. I hope this works!!

In your last post you said, "okay... I can see that workbook is uploaded. Now where to look into .. i.e., which cell ? Also mention your expected output. thanks." In response to that question I pointed out that in row three of the posted workbook page there is a text explanation of the problem. It may be that you can't see that explanation if you don't make row 3 high enough to see the three consecutive line of text there. You may have to also scan to the right of the page if your monitor is not wide enough to see the entire width of the page. Mine is not. Thank you for trying to help. I think that we can get this solved if we keep talking back and forth.

In your last post you said, "okay... I can see that workbook is uploaded. Now where to look into .. i.e., which cell ? Also mention your expected output. thanks." In response to that question I pointed out that in row three of the posted workbook page there is a text explanation of the problem. It may be that you can't see that explanation if you don't make row 3 high enough to see the three consecutive line of text there. You may have to also scan to the right of the page if your monitor is not wide enough to see the entire width of the page. Mine is not. Thank you for trying to help. I think that we can get this solved if we keep talking back and forth.

Yes, you are correct. Can a macro be written that will execute automatically when I put in new data? I would need help writing that macro.

I don't want the entire range to change. I only want the the row that is on the same date line to have the values of AO34 put in. I was hoping that instead of transferring the formula to the right side of the sheet that only the value of AO34 would be placed on the right side of the sheet. After the value of AO34 is placed on the right of the sheet I never want it to change. Is that possible?

This is a good solution. Thank you very much for you help!! There is nothing wrong with your English, it's just fine. I have learned a lot form this thread, Thank you again.

No, I missed the changes to AM and AO, I am looking at them now. I am going to have to think about what I see. I am not the skilled programmer that you are. I can see that it works real well. I just don't see why yet. I may have to get back to you if I can't figure it out. Thank you. This is great!!

I really like the new formula in column AO. It's cleaner and simpler than mine. I don't understand the new formula in column AM. I know that it works, but I don't know how it works. Can you help me understand it?