How to sum items from column A only if Column B row equals X

B

BM

Hi all,

Here's an example of whan I'm trying to do:

Column A Column B
1 Add
2 Don't
3 Add
4 Don't


Add values in Column A if the cell to the left of them equals "Add" ...
result should be 4


Any help would be appreciated.

Blue
 
Top