Summarising data.

From PM:

If I wanted to change the drop down list to dates rather than days of the week do I need to update the indirect formula?

So you will have a date, like June 17, 2009 and you want it to know that is a Wednesday and therefore look up the sheet named 'Wednesday', is that correct?

I actually now have to change the tab name and the drop down list to link as a date.

No days will be used a list of dates will be. A workbook will have all the days on the month and a summary sheet.

Hope that makes sense. Thanks for the reply btw!

Format of the date will be dd.mm.yy if you need to know.

Can you re-attach the amended sample workbook so that we are on the same wavelength?

Of course... Many thanks.

Apologies, realised what I needed to change. Think I have it sussed. Basically the format of the tab needs to be the exact same as the drop down list.

Although would this work if I wanted to change the format to say dd.mm.yy?
Many thanks NBVC.

You would need to replace all references to $C$5 with TEXT($C$5,"dd.mm.yy")

Remember to include the formula in AO of each of the sheets so that it works out. =IF(D2="","",SUM(S2,W2,AA2,AE2,AI2,AM2)>0)

NBVC,

When you mention to replace all references to C5
=COUNTIF(INDIRECT(TEXT($C$5,"dd.mm.yy")*C5&"!AO:AO"),TRUE)?