total

[jasman]

Hi. Have have 3 cells in a row that contains currency and by default it has £0.00 until a value is updated in them. I want to create a cell at the end of the row which totals the 3 amounts together, but if all the cells contain £0.00 then nothing should be entered in the total cell. At the minute it enters £0.00 in the total cell.

Thanks

 

[VoG]

Try like this

=IF(SUM(A1:C1)=0,"",SUM(A1:C1))

 

[jasman]

great works! thanks