I'm extremely new with excel and i have have searched all over the internet to try to learn how to do this. I am trying to count the amount of x's in a cell range then when those x's are removed keep the value it counted in a another cell. Basically is you have x in B7,B8,B9 Count it and put in cell T7 but when the x from B7,B8,B9 is deleted it still keeps the count in T7. When new data is added it keeps adding the count to T7.

Currently this is what i have in T7 =COUNTIF(B7:D7,"*x*")+COUNTIF(H7:J7,"*x*")+COUNTIF(N7:P7,"*x*")
What I have in U7 =COUNTIF(E7:G7,"*x*")+COUNTIF(K7:M7,"*x*")+COUNTIF(Q7:S7,"*x*")

I hope this make sense.

I posted a few screen shots of how I want it to work. Starting from the top, Starting Week Tracker, First Week Data Entry, After removing the data, and last 2nd weeks data entry.
Examples.png