Sum values from one column if another column equals x [Solved/Closed]

- Dec 1, 2015 at 03:25 PM - Latest reply:
Posts
1204
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
November 11, 2018
- Dec 2, 2015 at 12:20 AM
Hello,
Is there a formula that can calculate the sum of cells from one column if the value in another specific cell equals x (or not blank)? I tried =SUMIF(A:A,"x",B:B) but that didn't do it.

For example:
column A
5
10
5

column B
x
<blank>
x

The sum should be 10.

Thanks!


See more 

3 replies

Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
- Dec 1, 2015 at 03:45 PM
0
Thank you
Put this in a column other than A or B as you will get a circular reference error.
=SUMIF(B:B,"X",A:A)

Hopefully that works. I've not had a lot of lucky with these questions lately.
Thank you! That worked.
Posts
1204
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
November 11, 2018
> Sarah - Dec 2, 2015 at 12:20 AM
Hi Ray,

Sarah just made your day! ;-)