countif/criteria

[dodger999]

Guys,need help with a task for countif.the formula i have here on a data worksheet runs over 7 days each day on a seperate work sheet.what i need to do is be able to change the aylesford to say stora without manually typing each one in time consuming would you say i have abot 12 differrent names to insert. can anybody help.if i try to change it just gives me saturday

cheers

=COUNTIF(Sunday!$C$23,"Aylesford")+COUNTIF(Monday!$C$23,"Aylesford")+COUNTIF(Tuesday!$C$23,"Aylesford")+COUNTIF(Wednesday!$C$23,"Aylesford")+COUNTIF(Thursday!$C$23,"Aylesford")+COUNTIF(Friday!$C$23,"Aylesford")+COUNTIF(Saturday!$C$23,"Aylesford")