I've created a form and introduced logic for several responses. If the field is populated, a follow up question with radio buttons becomes visible, 'A' and 'B'. I want to be able to calculate at the sheet level the total of all questions answered 'A' and also calculate all answers calculated 'B'.
I assume an IF statement would be appropriate, but I've played around with it and have been unsuccessful.
Thanks for your help!
Help Article Resources
Check out the Formula Handbook template!