Sum if not blank

Now I get it.

Try something like this.

=IF(COUNT(Likelyhood@row:Proximity@row) < 1, "", SUMIF(Likelyhood@row:Proximity@row, <>""))

Did that work?

All comments

Hi @Cheryl Collins

I hope you're well and safe!

Try something like this.

=SUMIF(Likelihood@row:Proximity@row, <>"")

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

I'm good thanks Andree. Hope you are too?

It works but returns a zero, ideally this could just do with staying blank.

Thanks

I'm excellent!

It works for me. Can you share the formula you used and maybe a screenshot?

@Andrée Starå I used your formula:

=SUMIF(Likelihood@row:Proximity@row, <>""). This is what I get:

Do you want to sum the row or the columns?

If it's the row, it's correct. It should be 0 because the cells are empty, or have I misunderstood what you need?

@Andrée Starå

I want to sum the row but, I would like it to show as blank if there are no numbers in the previous 3 columns. This scoring is only applicable to Risks recorded on the project RAID log so, if an issue is recorded scoring will not be applied therefore, I would want the score to remain blank.

Would I be better with a sumif, based on type e.g:

=SUMIF(Type:Type, "Risk", [Likelihood@row:Proximity@row])

although this formula doesn't work but, you get the idea, I'm sure.

Thanks

Cheryl

Now I get it.

Try something like this.

=IF(COUNT(Likelyhood@row:Proximity@row) < 1, "", SUMIF(Likelyhood@row:Proximity@row, <>""))

Did that work?

@Andrée Starå

Perfect! That's cracked it. Thanks so much as ever for your help. 😊