G
Guest
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
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