How to find the value of a cell at the intersection of two xls table cells using openpyxl?

Question

Python

For example, when choosing Category 1 and 40, it gave the value 12 and so on

Answer 1

There are three ways:
1. Using excel - insert somewhere in the table a formula like "sumif" or "sumprod" with the appropriate parameters, like this: ; 2. Load the table into pandas, correctly specify the column names and index, and then refer to the dataframe by column names and indexes; 3. reinvent your wheel.
ws["A1"] = "=SUM(1, 1)"