Thanks.
I have gone through and added this formula to all the columns making the edits necessary for them to work. The COUNT function works to count the number of flakes in a panel but for the life of me I can not get the COUNTIF function to work.

I have added Type as a name referring to Column J (Knapping Type) these are recorded as either 'UF1' or 'UF2'. I have added two new columns to get the count of UF1 and UF2 which I will need to calculate their percentages.

This is the formula I've been trying but I can not get it to work. I keep getting the message that there is an error, I was just wondering if you can see what I have done wrong.?

=COUNTIF((INDEX(Type,$AJ2-1):INDEX(Type,$AK2-1)), 'UF1')