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

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

=SUMIF(B1:B4,"Add",A1:A4)

--
HTH

Bob Phillips

"BM" wrote in message
...
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