Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |