Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
In Excel - can I create a formula based on a filter?
I'm using Excel to create a report based on survey results. For example, for
the % of users who got a first response in less than a day, I have this: =(COUNTIF(SurveyReport!D2:D28,"less than a day"))/((COUNTIF(SurveyReport!D2:D28,"less than a day"))+(COUNTIF(SurveyReport!D2:D28,"1 - 2 days"))+(COUNTIF(SurveyReport!D2:D28,"3 - 7 days"))+(COUNTIF(SurveyReport!D2:D28,"longer than a week"))) Right now, I have to manually sort the data and enter the ranges each time I run the report, since the number of respondents changes each time. If the responses are in column D, and the question ID is in column A, is there a way to tell Excel "do this for every row where A=3"? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create database based on excel form | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
How can I create a formula out of more than 7 functions in excel? | Excel Worksheet Functions | |||
Create an if-then formula in Excel to limit column total? | Excel Discussion (Misc queries) | |||
How do I create a formula in excel to automatically copy text fro. | Excel Discussion (Misc queries) |