Using Sumproduct in Autofilter

[Guest]

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

 

[Bob Phillips]

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)