Download the featured file here https://www.bluepecantraining.com/vlookup-sum-all-matching-values-or-sum-entire-matching-row-or-column/
This video looks at summing values returned by a lookup formula. Each summing calculations uses a single cell.
The video demonstrates how to sum all matching values (multiple lookup values) and how to sum all values contained in the matching row or column.
The functions featured in the video are XLOOKUP, VLOOKUP, LOOKUP, INDEX, MATCH, SUM, SUMPRODUCT.
------------------------