Thread: Changing cell values depending on drop down selection

I want to have a summary sheet to pull information depending on the selections from a drop down list. So if Janurary is selected from the drop down I want the cells to display the data relating to that month. I have the workbook set up with a worksheet for each month.

I am using this forumla: -

=COUNTIF('Oct 08'!V1:V8930,"G*")

But I want the 'Oct08' to change depending on the month selected?

Any ideas?

Well if the value from the dropdown is in cell E1

=COUNTIF(INDIRECT("'"&E1&"'!V1:V8930"),"G*")

or if the date is a date in the dropdown

=COUNTIF(INDIRECT("'"&TEXT(E1,"mmm yy")&"'!V1:V8930"),"G*")

Is that what you mean?

Regards

Dav

Yeah that is what I mean, now If I could make it even more complicated. I would like to use to criteria to filter i.e. two drop downs

do it would be

countif(Drpdwn1&drpdwn2)

So I assume I'll have to use an array for this?

Actually just looking at that forumla I don't think it's right? I assume I'll have to have the sheet references on an indirect link, like a lookup depending on what is selected from the dropdown?

i.e. For a Janurary selection the countif will have to change to =COUNTIF(INDIRECT('Jan 09'!A1:T360,G*)

Would that be right?

Any Ideas?

Why do you not evalute the suggestion, it will change to the names of the sheets if the names are the same as the dropdown you are selecting them from

If you are wanting to countif with 2 critieria the same logic can be applied to a sumproduct formula or a concatenation using a counit formula also look at ratcat's suggestion

Regards

Dav