Hi

=IF(COUNT(A5:A9,A4)0,SUM(A5:A9,3*A4),"no result")

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Haz" wrote:

Hi,

I would like to return 'no result' if the cells in the sum below are empty.

=sum(a5:a9)+(a4*3)

I think I need an if function in the sum above so if all cells
A4,A5,A6,A7,A8 & A9 have no values in then give 'no result''. If any of these
cells have a value which may come to 0 then give 0 or any other value of the
sum.

hope this clear I can't get this to work

Thanks