If we want to find out the numeric value then the lookup function may be not the best option because we have to use helper column or array formulas. The easiest approach would be to use SUMIFS function which is designed to add up values from numbers & include only rows that meet the given condition.
Let us understand with an example:
In this way, we can sum based on the meeting all the specified conditions.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.