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

Auto populate value from one task to another in MS PROJECT 0
Lookup function to return highest value 4
Help with a running total on multiple sheets 2
comparing sheet to sheet and adding value 1
Auto Populate Sheets by Employer 1
Page numbering with Merged Document and IF statements 1
Need a function to match unidentical strings 0
Totaling Categories - Monthly and YTD 2

Top