Calculate average based on user selection
Hi
This should be simple, but I don't have an answer. How do I calculate the
average of a range of values based on a user selection. I have drop down
box with the months, which the user selects the month. It should then
calculate the average up to that month (Year to date). Here is the data:
Month Members
Jan 250
Feb 300
Mar 475
Apr 389
So, the user selects Mar then the average from Jan to Mar is 341. The user
makes another selection and selects Feb, then the average from Jan to Feb is
275. So, everytime the user selects the month, the year to date average is
calculated.
Thanks in advance.
William
|