P
Porky79
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
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