Dynamic Forumlas based on Dropdown

[Guest]

The following is an abstract of a forumla i'm working with to summarize
points in column BB (which is for January).

{=SUM(('Everyone FCST'!BB1:BB2000>0.1))}

If I add a drop down in the excel sheet so users can change columns to
diffferent months (columns BC, BD, BE, etc.) is there a way the forumla will
automatically change to search the newly selected column. Example:

{=SUM(('Everyone FCST'!BC1:BC2000>0.1))}
Thanks so much for any help anyone can provide!!!!

 

[Guest]

Try something like this:

With
A1: (contains the dropdown list...Jan, Feb, etc)
and
Col_BB contains Jan values

Try this:
=COUNTIF(OFFSET('Everyone FCST'!BB1:BB2000,0,MONTH(A1&"-01")-1),">0.1")

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP