0

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,"*"),""))
Improve this question
1
  • Welcome to StackOverflow! Please do NOT share images as the only source of data, to avoid closure of the question. Make sure to add input and expected output as a plain text table to the question. Click here to create a markdown table, which is easier to copy/paste as well. Also, note that your email address can also be accessed by the public, if you share Google files. Commented Jan 24 at 14:48

1 Answer 1

Reset to default
0

Unless I'm reading this wrong, this is just a basic addition and division? I didn't quite make out what was going in in your other columns with NA, but the count function will only do numbers, which appears to be what you want?

So throwing this into cell c21 and copying right, should work: =count(C$3:C$20)/count($C$3:$G$20)

Sample sheet here that loosely mimics yours. Total percentage sums to 100%.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.