Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using Sumproduct in Autofilter
Hi there
I want to know whether I can use sumproduct within an Autofilter to do the following. Column A: Company Name Columm B: Weight of the Company (based on a scale of 1 to five) on the amount of $ it spends per week Columm C: $ Spent per week Each week, Columns B and C will vary. I need to filter the companies at the end of year and calculate how much they spent on average. I need to account for the weekly weights and the dollar spent per week. How do I do this? Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using Sumproduct in Autofilter
If you have filtered by name, you can just use SUBTOTAL on the results, such
as =SUBTOTAL(1,B2:B10) for the average -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "forest8" wrote in message ... Hi there I want to know whether I can use sumproduct within an Autofilter to do the following. Column A: Company Name Columm B: Weight of the Company (based on a scale of 1 to five) on the amount of $ it spends per week Columm C: $ Spent per week Each week, Columns B and C will vary. I need to filter the companies at the end of year and calculate how much they spent on average. I need to account for the weekly weights and the dollar spent per week. How do I do this? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMPRODUCT with Autofilter | Excel Worksheet Functions | |||
Using AutoFilter + sumproduct formula | Excel Discussion (Misc queries) | |||
SUMPRODUCT and (perhaps) SUBTOTAL with AUTOFILTER | Excel Worksheet Functions | |||
How to Sort within AutoFilter with Protection on (and AutoFilter . | Excel Discussion (Misc queries) | |||
Autofilter? | Excel Discussion (Misc queries) |