Sum, count or average with partial matches

Please purchase the course before starting the lesson.

As with the VLOOKUP function, the match is assumed to be an exact match i.e. if you are looking for Smith, Excel won’t match it to a cell containing John Smith. But there is a way to make Excel work with this partial match.

Watch the video clip to see how this works.

To see the full course contents clickĀ here.

Back to: Advanced Excel Course > SUM, COUNT, AVERAGE IFS