How to setup formula to collect ongoing information

  • Thread starter Thread starter Darlene
  • Start date Start date
D

Darlene

I have setup a questionnaire which will continuously have an answer section
added to it. I am setting up a formula to count the yes and no answers. How
would I set a formula up to count all the ongoing answers? Example would be
=COUNTA(B6:G6) but then I add another two column of answers and need the
formula to now read =COUNTA (B6:I6). Do I need to keep adding a new formula?

Thank you.
 
Thank you Pecoflyer but not sure how to set this up because I only want every
other cell to be added (horizontally). The answers are yes and no. So I
need a formula to add every other cell across for yes and every other cell
across for no answers. How would I set that up with the dynamic range.
Really appreciate your help!
 
Back
Top