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

Report
-
Posts
1292
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
May 7, 2021
-
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

Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
24
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
1292
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
May 7, 2021
230 > Sarah
Hi Ray,

Sarah just made your day! ;-)

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!