Count or Sum formula

Cheryl C · 03/19/25

I want to sum the columns that contain 1 and have tried a SUMIF and COUNTIF Formula, as well as using the AI formula generator within the sheet - nothing is working. As you will see from the screen shot below I would be expecting this column to return a value of 7 but, it just returns 0.

I know it's going to be something really stupid / simple but, I just can't work out the issue.

TIA

Cheryl

Paul Newcome · 03/20/25

Did you make that update removing the quotes in all of the columns being referenced?

Paul Newcome · 03/19/25

How exactly are you populating the ones and zeros?

Cheryl C · 03/20/25

Hi Paul

They are being populated via a formula - see example below:

Many thanks

Cheryl

Paul Newcome · 03/20/25

Try removing the quotes from around the one and zero.

Cheryl C · 03/20/25

Hi Paul

No, that's still returning a 0

Paul Newcome · 03/20/25

Did you make that update removing the quotes in all of the columns being referenced?

Cheryl C · 03/20/25

Thats cracked it! Knew it was going to be something super simple. Thanks

Paul Newcome · 03/20/25

Happy to help. 👍️

Count or Sum formula

Best Answer

Answers

Help Article Resources

Categories