Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I write a comlicated conditional statement?
I have a survery with 10 answers. How can I write a conditional statement
that will display the number of times a certain answer comes up within a week that I designate. Entries are added all the time do I don't want it to be dependent on row position. I've used a COUNTIF statement to count how many times an answer is given in a certain column but I don't want to have to designate what that column is every time since I will be adding more rows on a regular basis. In regular ol' english, I need it to: Search a column of dates (sorted in ascending order) and find the rows (each survey) that fall between 2 dates that I specify in 2 certain cells. Once it finds the rows between those dates, count the number of times a certain answer was given in another column. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Share write protection fails | Excel Discussion (Misc queries) | |||
Conditional formula - language needed | Excel Worksheet Functions | |||
Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
How can I use HYPERLINK in a conditional statement between sheets | Excel Worksheet Functions | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |