Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to setup formula to collect ongoing information
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. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to setup formula to collect ongoing information
Hi, easiest way is using 'dynamic ranges' (http://www.contextures.com/xlNames01.html#Dynamic) HTH -- Pecoflyer Cheers ------------------------------------------------------------------------ Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=30624 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to setup formula to collect ongoing information
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! "Pecoflyer" wrote: Hi, easiest way is using 'dynamic ranges' (http://www.contextures.com/xlNames01.html#Dynamic) HTH -- Pecoflyer Cheers ------------------------------------------------------------------------ Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=30624 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ongoing hyperlink problem | Excel Discussion (Misc queries) | |||
how do i stop rows from being ongoing | Excel Discussion (Misc queries) | |||
Collect numbers.... | Excel Discussion (Misc queries) | |||
collect data from different worksheet | Excel Worksheet Functions | |||
Need formula for a fixed cell minus last entry on ongoing log | Excel Worksheet Functions |