Create a table with columns "Competitor", "Price", "Market Share" and use the AVERAGE and COUNTIF formulas for analysis.

But automatic collection of source data from competitors' websites is a separate task.

To calculate data based on multiple conditions, for example, the market share of competitors with a low price, you will find useful a detailed breakdown of the SUMIFS function in Excel with examples.

🔗 Source: excel.rf