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
|