Excel array formula help

[pwl2706]

Hi,

We have a workbook with one sheet for each month, and on each month we have a list of web sites with some data provided by that website.


The list of websites is different from month to month, but always between A2:A13.


On my summary sheet I need a dynamic list of the available websites plus the sum of column 2 on each sheet.


So for example column A on January might have moneysavingexpert.com, and column B would have a value, on my summary sheet

I want to sum all of the month data for moneysavingexpert.com wherever that site is found

data provided by that website.
The list of websites is different from month to month, but always between A2:A13.
On my summary sheet I need a dynamic list of the available websites plus the sum of column 2 on each sheet.
So for example column A on January might have moneysavingexpert.com, and column B would have a value, on my summary sheet I want to sum all of the month data for moneysavingexpert wherever that site is found
I have started like this:
In column B of my summary sheet I put this INDEX/MATCH formula for January & February and it works:

=INDEX('January '!$A$2:$B$11,IF(ISNA(MATCH('Top ten summary '!B13,'January '!$A$2:$A$12,0)),0,MATCH('Top ten summary '!B13,'January '!$A$2:$A$12,0)),2)+INDEX(Feburary!$A$2:$B$11,IF(ISNA(MATCH('Top ten summary '!B13,'January '!$A$2:$A$12,0)),0,MATCH('Top ten summary '!B13,'January '!$A$2:$A$12,0)),2)

But ideally I don't want to have to repeat this for all months, and as I said, a dynamic array would be better.
What is the best approach to this, to do it dynamically?

 

[GerryZ]

@pwl2706
Hi whatch thi video from Excelinfun
https://www.youtube.com/watch?v=2b_eSP6DNsw
or
https://www.youtube.com/watch?v=BsnhWRgghRk
let me know!
bye