Search for value in one column, sum a different column

[paul_carron]

Hi,

I have a query but I'm not sure if it's even possible to do.

If I enter a name into cell J1 I want to check for this name in column H then for each row that is found on I would like to sum column B and output the result to cell J2. E.g. If I enter Paul into J1 I would like to search for this name in column H. For every row this is found on I would like the B cell for that row to be included in a sum of which the result is output to cell J2.

Is this possible and if so does anybody know how?

Cheers
Paul

[Kevin UK]

Hi paul_carron

Try the SUMIF/SUMIFS functions.

[paul_carron]

That was quick. Thanks very much.

[Kevin UK]

No problem Paul and thanks for the feed back.