Hi,

I'm new here - First post (and a novice at excel) so bear with me if I'm being a little slow with this.

I have a workbook with 6+ Sheets, and within each sheet multiple rows that contain an area - then in the following columns that area's performance as a percentage (number).

I would like to create an overall performance table, that will compare all the rows (areas) and utilising an if function (or something like that) only include that row if it's column's value is above a certain threshold,
this would act as a sort of overall sheet summary. (for example, I know something similar could be achieved in python by iterating over a list, and storing the results in a separate list.)

Secondly, I would like to have a table that breaks down performance by area (Row) and summarises that area's overall performance (e.g just shows that row's data for each sheet)

I have no clue how to do this, but would quite like to learn how to. Any input would be greatly appreciated.

Thanks.