Currently I have a formula: =IFERROR((C2)/(B2-F2-G2-H2
A new requirement has been added, I now need to be able to count for D2 as well.
The problem is that if B2=1 and C2=1, I get 100% which is correct, but if I count D2 as well it will give me 50%. I need to be able do something will only count C2 or D2 but not both. B2 changes based on how many students.
B2 comes from: =COUNTIF('PTA Credential '!A:A,A2)
C2 comes from: =SUMPRODUCT((fm=Counts!A2)
D2 comes from: =SUMPRODUCT((fm=Counts!A2)
If I use: =IFERROR((C2+D2)/(B2-F2-G2
,"") instead of 100% it will be 200% which cant be with only 2 students
I'm in over my head on this. It's probably simple, but I havent worked on Excel for a good while.