0

I have column A with some numbers and column B, where some cells are empty and some cells contains '+'. And I want to sum cells from Column A, but only cells in rows where B column contains '+'.

For example:

A    B
1    +
2    
3    +
4    

So I want to sum 1 and 3 and get 4.

Can anybody help me?

2
  • Define "summarize" please.
    – Marc
    Nov 13, 2012 at 21:58
  • Get sum. 1 + 3.
    – Igor Ryzhov
    Nov 13, 2012 at 21:59

2 Answers 2

1

SUMIF should do it, as in:

=sumif(B1:B4,"+",A1:A4)

0
1

Here ya go:

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .