# Thread: Multiple matches in a column - need to sum up their matches. Thanks: 0 Likes: 0

1. ## Multiple matches in a column - need to sum up their matches.

So in my example, in column A, I would like to look up the letter "B", and then look under the month of January, and sum up the number of "B"'s that is returned under that column. I just want the one row for the sum of B's. I dont want to have multiple cells that I still have to solve for, and I dont want to hide cells. Under the Cell for B, I might want to look up the Number of any letter in a particular month.

Does that make sense?

Thanks

Lawrence

2. ## Re: Multiple matches in a column - need to sum up their matches.

Is this what you mean?
If not, please provide & explain the expected results for the sample data given.

BTW, You will get many more potential helpers if you post a small (copyable) screen shot or two directly in your post, rather than an image where the data cannot be pasted into Excel in a meaningful way. My signature block below has help regarding that.

Formula in B10 is copied across and down.

SUMIF

 A B C 1 Jan Feb 2 B 6 0 3 A 5 3 4 B 3 4 5 C 2 4 6 D 3 10 7 B 5 5 8 9 10 B 14 9 11 C 2 4 12 A 5 3

 Cell Formula B10 =SUMIF(\$A\$2:\$A\$7,\$A10,B\$2:B\$7)

Excel tables to the web >> Excel Jeanie HTML 4

3. ## Re: Multiple matches in a column - need to sum up their matches.

i will remember that tip.

You have answered my question completely. I was trying to use lookup commands, and I just couldnt get it to work.

Thank you.

Lawrence

4. ## Re: Multiple matches in a column - need to sum up their matches.

Originally Posted by plahen
You have answered my question completely. I was trying to use lookup commands, and I just couldnt get it to work.

Thank you.

Lawrence
You are very welcome. Thanks for the confirmation.