Sum / Total Error

[ollyhughes1982]

[FONT=&quot]Hi, any help appreciated![/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]I have a spreadsheet and in column FO (highlighted yellow) I want to show the total of columns FN, FQ & HE. I have attempted this, but it only seems to work for some rows, I get errors in the others. All I want is for the column to total those other three (FN, FQ & HE) and if the result is 0 to show as blank.[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]You can find the file at the following link:[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]https://1drv.ms/x/s!AtIvkRgReIvwgRuh0tHLEJapsEZ0[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]Thanks in advance![/FONT]

 

[Fluff]

How about
=IF(SUM(FN4,FQ4,HE4)=0,"",SUM(FN4,FQ4,HE4))

 

[ollyhughes1982]

Thanks, that works great. I think I was trying to overcomplicate it!

 

[Fluff]

You're welcome & thanks for the feedback