Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LOOKUP a text string created from IF statement | Excel Discussion (Misc queries) | |||
Another way to lookup data | Excel Worksheet Functions | |||
Lookup Vector > Lookup Value | Excel Worksheet Functions | |||
Lookup function w/Text and Year | Excel Worksheet Functions | |||
double lookup, nest, or macro? | Excel Worksheet Functions |