Getting a total summation to be displayed only when all cells are populated

Vinton Douglas

Hello,

I have 3 cells which I want to add to provide a total. I only want the total to be displayed when all 3 cells are populated, otherwise to leave black (in my total column). Is this possible?

Andrée Starå

@Vinton Douglas

Excellent!

You're more than welcome!

I assumed they were beside each other, and then all three columns would be included.

Are they not beside each other?

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

Andrée Starå

Hi @Vinton Douglas

I hope you're well and safe!

Try something like this.

=
IF(COUNTIF([Column 01]@row:[Column 03]@row, <>"") = 3, 
SUM([Column 01]@row:[Column 03]@row))

Did that work/help?

I hope that helps!

Have a fantastic weekend & Happy New Year!

Best,

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

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

Vinton Douglas

Hi Andrea,

Thanks much.Its not going through. I tried using the below with my 3 columns:

=IF(COUNTIF([Duration(mins) In ER Prior to Trolly to Rad Dept]@row:[Duration from Arrival in Rad to Completion of CT]@row:[Duration from Completion of CT to Reading of CT]@row,<>"")=3,SUM([Duration(mins) In ER Prior to Trolly to Rad Dept]@row:[Duration from Arrival in Rad to Completion of CT]@row:[Duration from Completion of CT to Reading of CT]@row))

Andrée Starå

@Vinton Douglas

Happy to help!

Try this.

=IF(COUNTIF([Duration(mins) In ER Prior to Trolly to Rad Dept]@row:[Duration from Completion of CT to Reading of CT]@row,<>"")=3,SUM([Duration(mins) In ER Prior to Trolly to Rad Dept]@row:[Duration from Completion of CT to Reading of CT]@row)

Did it work?

Vinton Douglas

Hi Andrea,

Thanks again. This is only summing up 2 columns and not the third one. As you can see in the above formulla I am trying to complete. Can you say what I am doing wrong?

Andrée Starå

@Vinton Douglas

Excellent!

You're more than welcome!

I assumed they were beside each other, and then all three columns would be included.

Are they not beside each other?

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

Vinton Douglas

Hi Andree,

They are beside each other, but it only captures 2 column- see screenshot.

Screen Shot -Count IF.png

Vinton Douglas

Hi Andree,

Just inserted again and it is now working well. Thank you very much.

Andrée Starå

@Vinton Douglas

Excellent!

You're more than welcome!