Sum values from one column if another column equals x

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


1 reply

RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 25
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.
1
Thank you! That worked.
0
vcoolio Posts 1362 Registration date Thursday July 24, 2014 Status Moderator Last seen September 29, 2022 250 > Sarah
Dec 2, 2015 at 12:20 AM
Hi Ray,

Sarah just made your day! ;-)
0