Hi guys -

I have a worksheet that contains a summary of data that is entered in
a different part of the same worksheet (i.e. Page 1 in the worksheet
is the printable report).

I want to hide a title in the summary section (lets say this is cell
A1) unless data is filled into any cell in a specified row
(J14:T14).

Using the IF principle I thought I could use =IF(J14:T14,I14,"") -
where J14:T14 is the row where data is entered and I14 is the text
that I want displayed in A1 should there be data entered in this row.

comes up with #VALUE!

Any ideas where I am going wrong or if this is actually possible?

Thanks