Hi all,

Here's the scenario - I have a file I use for sales forecasts, laid out as
follows:

Client Name - G6:G709
Product Name - UB5:AAM5 (12 groups of repeating names)
Data to be added - UB6:AAM709

I need a formula for a summary sheet that can calculate the revenue per
product name per client for the year (so adding the 12 periods), and that
will also work when the source data is filtered, if possible.

Thanks for any help & suggestions.

Cheers,

Alan