Hi

I need some help with i think a vlookup formula.

I have a spreadsheet that calculates services done by shops.

there are 8 sheets 1 for each day of the week and 1 summary.

On the daily sheets there are 30 drop down boxes where the individual can
input a sevice in each box.

On the summary sheet there is a table which breaks down the number of
individual services and i want it to automatically pull how many of each
services have been done over the whole week i.e tabs 1-7

Can anyone help?

phill