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
|