I have a Workbook that collects monthly data on seperate sheets(January!, February!...)
There is a summary sheet that has formula:
=countifs(January!a1:a1000,"Strategy*",January!b1:b100,"Appt*")
@A1 in the summary the month can be entered. i.e. January, February.... (it is a list-so syntax is not a problem)
I would like the formaula to be:
=countifs(Text(A1,"")!A1:A1000,"Strategy*",Text(A1,"")!B1:B1000,"Appt*")
So that the month can change in cell A1 and that will cause the formula to look at the corresponding worksheet.
Thanks for any help.
Bookmarks