It is in a lesson plan I am working on. The drop down changes weekly and I want to add the drop down menu for an running overall total. I found out how to transfer the calculation to another spreadsheet, but when I change the drop down menu for another week the area changes to zero. Can anyone help me?

I don't understand what you are doing/trying to do.

"The drop down changes weekly and I want to add the drop down menu for an running overall total"How does the drop down change weekly? The choices available or the currently choosen value?

What does "add the drop down for an running total mean"?

I found out how to transfer the calculation to another spreadsheet....What calculation?

Keep in mind that we can't see your spreadsheet from where we're sitting, so we have no idea what the drop downs contain, how they change, or how you use your spreadsheet.

You have to provide the detais as to the layout and the use before we can offer any suggestions.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

I am a teacher and have a lesson plan template. I pick weekly which standards I teach from a drop down menu that has 20 standards for reading. I wanted to tally the number of times I teach each reading standard. For example, I teach RL.1.1 first week, RL. 1.6 second week, RL.1.1 third week. I want to see at the end of the school year how many times I have taught each reading standard.

You could do somthing like this: With your data like this:

A B C D 1) List Total Date Course 2) RL.1.1 2 04/15/2013 RL.1.1 3) RL.1.2 0 04/22/2013 RL.1.6 4) RL.1.3 1 04/29/2013 RL.1.3 5) RL.1.4 0 05/06/2013 RL.1.1 6) RL.1.5 0 7) RL.1.6 1 8) etc. etc.Column A is your course list, not sure how they are numbered.

To make life easier, we are going to Define a Name for the list.Define Name:

Select your list of cells,

If you have 20 RL courses then it should be A2 : A21.On the Ribbon, Select the Formula Tab

Select Define Name

In the popup window, enter a name for your list, like: RL_Courses

Check at the bottom of the window that theRefers Tobox

show the correct range of cells. Something like: =Sheet1!$A$2:$A$21

Click OKWere going to jump over Column B to column C which is simply the Date

a RL course was taught, which you input manually.Column D is your Drop Down list of RL Courses.

Back to Column B, which is your Totals column and has the formula:

=COUNTIF($D$2:$D$44,RL_Courses)

It will count, in column D, from row 2 thru row 44

the number of times each course is selected.See how that works for you.

MIKE

Ask Your Question

Weekly Poll