Yes this the results, I am looking for place upon the sample data you have illustrated, but it's a little cumbersome, and still has to be manually updated will I add a new row.

I want the table to update every time I add a new row or two.

I am only adding one row of data at a time. Also some of the cells in the column are blank or empty and I will probably have to look at the last 25 rows or less to get the last 10 numerical entries and 220 rows to get the last 100 numerical entries, then count how many of those are the number 3, 2, 1, and 0 exist.

So if I have 150 rows, I may have to go back 22 to 25 rows back to get the last 10 numerical entries to calculate, which would possibly be 125 to 150, then calculate. Next, I add 2 rows with one row of data and the other empty, My table should update by calculating going back to rows 129 to 152 to get the nesxt last 10 numerical entries.

I want the problem the total the number of #3, #2, #1 and #0 in the U column

since the last 10 and 100 numerical entries in the column.

Below is an example of the table I want to automatically update after every numerical entry:

....................3.................2...............1..................0

last 10:.....ED23=2,;......EE23=4,......Ef23=3,...........EG23=1

%..........ED24=20%,. EE24=40%,.. Ef24%=30,....EG24=10%

last 100:... ED25=19,.....EE25=30,.... Ef25=30,....... .EG25=21

%..........ED26=19%,.. EE26=30%,.. Ef26%=30,... EG26=21%

Example of last the 10 numerical entries, relating to the above example

Column U

U13= blank

U14= blank

U15= 3

U16= blank

u17= 2

u18= blank

u19= 2

u20= blank

u21= 1

u22= blank

u23= 3

u24= blank

u25= 1

u26= blank

u27= blank

u28= 1

u29= blank

u30= 0

u31= blank

u32= 2

u33= blank

u34= 2

Maybe, a couple of formulas or function will work, that would look at the entire column

for the last 10 or 100 numerical entries and return how many are 3, 2, 1 or 0

numbers are in both categories (10 and 100 numerical entries). Then give the percentages.