Sum of values in a column if text in the same row of adjacent column matches

[michiganfan2]

I need to sum values in a column, but only if the text in the same row of the adjacent column meets certain criteria. Below is a simplified version as an example:


A1 - Apple
A2 - Banana
A3 - Apple
A4 - Banana

B1 - 3
B2 - 2
B3 - 1
B4 - 1

I need a formula that will add up the cells in column B that have "Apple" next to them in column A. Apple would total up to 4 and Banana would total up to 3.

Please help!

 

[Joe4]

Welcome to the Board!

Look at the SUMIF function in the Excel help files. SUMIF sums certain cells, based on criteria (exactly like you want).