Solved I want to count the number of times a drop down menu changes

May 5, 2013 at 11:34:04
Specs: Windows 7
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?

See More: I want to count the number of times a drop down menu changes

Report •


#1
May 6, 2013 at 08:33:19
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.


Report •

#2
May 11, 2013 at 05:14:45
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.

Report •

#3
May 11, 2013 at 08:56:16
✔ Best Answer
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 the Refers To box
show the correct range of cells. Something like: =Sheet1!$A$2:$A$21
Click OK

Were 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

http://www.skeptic.com/


Report •

Related Solutions


Ask Question