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).
Bookmarks