| Subject: Linking Workbook |
| Group: microsoft.public.windows.developer.winfx.general |
| Date: 8/21/2008 2:51:06 PM |
| From: =?Utf-8?B?U2Ft?= [Email Address Protection] |
I have a workbook. On the summary tab, I need a formula that will link to the Data tab and search by category (i.e Advertising, Hardware, Maintenance, IT) and bring back the count of vendors that it takes to reach 80% of the total results. For example, Advertising Total is $26,200. Therefore, Vendor A and Vendor D would total 80% + of the total, so the results would bring back 2 on the Summary tab. Summary Tab Advertising Hardware Maintenance IT Spend in USD $26,200.00 $5,200.00 $10,500.00 $6,100.00 Number of Suppliers account for 80% Data Tab Vendor Total Advertising Hardware Maintenance IT Overall Result $ 48,000.00 $26,200 $5,200 $10,500 $6,100 Vendor A $ 13,000.00 $10,000 $1,000 $2,000 Vendor B $ 7,000.00 $4,500 $2,500 Vendor C $ 6,700.00 $2,200 $3,500 $1,000 Vendor D $ 21,300.00 $14,000 $1,700 $5,000 $600 Thanks. |
| Back |