SUM Formula ignoring 0 Help!!

[stephen.smith]

Hi Guys
I am trying to perform a formula to sum a number of cells e.g. =sum(B5:P5), however if there is no figures in these cells I would like the cell to remain blank. Can anyone help with this please.
Thanks
Stephen

 

[Steeviee]

=if(sum(B5:P5)=0,"",sum(B5:P5))

 

[Sektor]

@if(sum(b55)=0,"",sum(b55))

 

[stephen.smith]

Thats great guys, also is there an average formula that ignores the 0 in making an average and also will display if there is no values in the cells to average that it will not display a value in the cell.
Thanks

 

[Steeviee]

=AVERAGE(IF(B5:P5>0,B5:P5))

****you must hold down the cntrol + shift keys when you press enter.

This will put curly brackets {} around the formula, making it an array formula. (There's lots of stuff in the archive here about arrays if you want to learn more.)

 

[Sektor]

Set custom format:
#;#;;
and use formulas as usual