I couldn't see a fix for this after doing a few forum searches, so I'm hoping you fine people can help.
Easy enough so far.
I've then asked the formula to express amount of 'Yes' answers as a percentage in T6 and T7 (100% and 75% respectively) by using the COUNTIF and COUNTA functions.
Again, easy enough.
Here's the question I need to answer: How do I stop the rest of the cells displaying a #DIV/0! error message when there's nothing to count in columns E, H, K, N and Q? Ideally I'd like the cells just to stay blank until text is inputted in the respective row, but my Excel knowledge isn't up to it.
Thanks in advance guys.