# Sum values from one column if another column equals x

Solved/Closed
Sarah - Dec 1, 2015 at 03:25 PM
vcoolio Posts 1409 Registration date Thursday July 24, 2014 Status Moderator Last seen May 23, 2024 - 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!

Related:

## 1 response

RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 26
Dec 1, 2015 at 03:45 PM
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.
vcoolio Posts 1409 Registration date Thursday July 24, 2014 Status Moderator Last seen May 23, 2024 262 > Sarah
Dec 2, 2015 at 12:20 AM
Hi Ray,