Written by 
TDA Reporting Chart Each column identifies where a particular student falls in their lexile readings. I am trying to place a percentage by adding up the columns and comparing it against the remainder of the columns. For example in column C 9 kids out of the 17 scored less than 39 on TDA 1. I would like the formula to add that up and then calculate what that percent is against the other columns totals are in the TDA 1. If you add up the totals in TDA 1 on Row 21 they should add up to 100%. N/a would not against the student who didn’t take the TDA.
I came across the formula that someone tried to use but it doesn’t make sense and I think it is incomplete but i cannot figure out what they did wrong.
=TO_PERCENT(IF(COUNTIF(C4:G20,”“)>0,COUNTIF(C4:C20,”“)/COUNTIF(C4:G20,”*”),””))