How does one auto-change values?

D

Darin

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.
 
G

Gary''s Student

In Sheet1, enter:

=COUNT(Sheet2!A:A)

This will count the number of dates entered in Sheet2 column A
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to limit validation list 3
Adding values in sheets and putting them on a summery 2
Auto Change Formulas - Please Help. 2
VBA: How can I use a string variable as autofilter criteria? 4
Need VLOOKUP to Work Two Ways 0
Lookup problem 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Copy corresponding cell in Column B if cell in A contains certain text? 1

Top