Thread: lookup?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
phill phill is offline
external usenet poster
 
Posts: 7
Default lookup?

HI

I HAVE A SPREADSHEET WHICH IS USED TO COLLECT HOW MANY SERVICES A SHOP DOES
EACH DAY.

I HAVE A SHEET FOR EVERY DAY AND A SUMMARY SHEET.

IN EACH DAY THERE IS A DROP DOWN BOX WITH A NUMBER OF SELECTABLE SERVICES
AND ON THE SUMMARY SHEET A COLUMN WHICH I WANT TO ADD UP HOW MANY OF EACH
SERVICES HAE BEEN SOLD THAT WEEK.

IS THERE A FORMULA THAT CAN DO THIS FOR ME?

MANY THANKS

PHILL