First, I would look into pivot tables. I like them for analysis , but a bit
tricky to work into monthly production stuff.

I would look into the "sumif" statement if you are looking for totals. On
the summary sheet , put the name you want to sum. From your example , you
may want to concatinate "product name & client " (I would have one colum to
go after , but sumif can do mult)

Sumif(Range to look and compair , thing you want to compair , range to sum
up and total)

"Alan Smith" wrote:

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