Hi Kristen,

You can use the SUMIF function to achieve this. Here are the steps:

1. Select the cell where you want the sum to appear (E6 in this case).
2. Type the following formula:
   Formula:

   =SUMIF(F:F,"B",E:E) 

3. Press Enter.

This formula will add up all the values in column E where the corresponding cell in column F is "B". If the cell in column F is anything else, it will not be included in the sum.

You can copy and paste this formula to other cells in column E and it will work for the entire columns E and F.