=IF(VariousCell="Week",COUNTIF(Combined!U:U,CONCAT ENATE(A6,"Yes")),IF(VariousCell="Month",COUNTIF(Co mbined!X:X,CONCATENATE(A6,"Yes"))

This cell is linked to Various cell which is a drop down containing month,
week, year. If you select Week it counts data in a concatenated column which
is up until that week you have selected. This is possible as the weeks
contain numbers i.e. Week 01, Week 02 and excel is able to read the number
prior to the week you have selected. This is not possible with the month as
it is displayed as text November, December etc and excel cannot give this a
value. Does any oine know how to overcome this problem??????