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

lookup?
 

Should be able to do this with a COUNTIF function
--
John
MOS Master Instructor
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"phill" wrote:

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