How to extract values in one column based on criteria in another column

I have a long column in excel with only a few of the cells containing data. What I would like to do is for those cells in this column that contain text, I want to pull the content of cells in another column that are in the same row as those cells with text.

excel question example.PNG

The attached file is a simple example. I want to match all the cells in the column labelled 'Year' that have 'x' for text with the associated row of data from the column labelled 'Value' whether the are G's or H's. I'd like it to return a sum of those 2 sets of data if possible (total number of G's and H's respectively).

Try this, adapt as required.

Please Login or Register  to view this content.

This will work well for counting particular text in the column (x's) but I want the match to work with the criteria that 'x' could be any text at all and if there is text then pull the corresponding value.

That worked excellently! thank you!