Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula for spreadsheet/tabs
Hi,
I have spreadsheet with following. The "Details" tab contains almost 200 customers names & acct number along with information for four different products (4 columns) which are sumed at total monthly the "Summary" tab has to show customer with total dollar amount monthly which I as of now am linking it manually. The summary tab has the customer names but needs to pull information each month from the detail tab monthly, is there a way to automate this? please advise thanks for help in advance TJ |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula for spreadsheet/tabs
Yes with SUMPRODUCT. But we need more detail to give you a full answer.
Want to send me a dummy workbook? (my private email, not the newsgroup) -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "TJ" wrote in message ... Hi, I have spreadsheet with following. The "Details" tab contains almost 200 customers names & acct number along with information for four different products (4 columns) which are sumed at total monthly the "Summary" tab has to show customer with total dollar amount monthly which I as of now am linking it manually. The summary tab has the customer names but needs to pull information each month from the detail tab monthly, is there a way to automate this? please advise thanks for help in advance TJ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Naming Spreadsheet Tabs | Excel Discussion (Misc queries) | |||
Is there a formula to capture data between "Tabs" on a spreadsheet | Excel Worksheet Functions | |||
selecting spreadsheet using tabs? | Excel Discussion (Misc queries) | |||
how many tabs on a excel spreadsheet can you have? | Excel Worksheet Functions | |||
Spreadsheet Tabs | Excel Discussion (Misc queries) |