Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How does one auto-change values?
Using Excel 2007. Multiple sheets in one workbook and each containing a list
of "Questions" in column B. As each each is answered, a date is placed in Column A next to that question. Sheet 1 in the Workbook contains a Category list in Column A, a total for # of questions in each Category in Column B and how many have been completed in Column C. Column D contains a formula for displaying percentage of questions completed in each particular category. Need to auto update Sheet 1's values. EX: As dates are entered next to Sheet 2's "Questions", the # of questions completed column on Sheet 1 would automatically increase. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How does one auto-change values?
In Sheet1, enter:
=COUNT(Sheet2!A:A) This will count the number of dates entered in Sheet2 column A -- Gary''s Student - gsnu200791 "Darin" wrote: Using Excel 2007. Multiple sheets in one workbook and each containing a list of "Questions" in column B. As each each is answered, a date is placed in Column A next to that question. Sheet 1 in the Workbook contains a Category list in Column A, a total for # of questions in each Category in Column B and how many have been completed in Column C. Column D contains a formula for displaying percentage of questions completed in each particular category. Need to auto update Sheet 1's values. EX: As dates are entered next to Sheet 2's "Questions", the # of questions completed column on Sheet 1 would automatically increase. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting does not change when values change. ?? | Excel Worksheet Functions | |||
auto change | Excel Worksheet Functions | |||
HOW DO I CHANGE AUTO FILL DATE VALUES | Excel Worksheet Functions | |||
Auto Identify Values | Excel Discussion (Misc queries) | |||
Auto insert values? | Excel Discussion (Misc queries) |