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

[plahen]

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

 

[Peter_SSs]

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.

Excel Workbook
	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
SUMIF

 

[plahen]

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

 

[Peter_SSs]

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.