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 |
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 |
All times are GMT +1. The time now is 11:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com