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

  • Thread starter Thread starter BM
  • Start date Start date
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum Values from different column 1
how to count#cells w/= value in other column and not count blank c 4
Count column b if column a equal cell value 7
SUM - IF - AND 7
Set non-continuous PrintArea via Function / Name 0
How do I count # of cells with same value other column? 4
Formula for adding sums 3
Sumif with multiple sum ranges in a sheet 4

Back
Top