Hi
I'm looking for some help and not entirely sure if it's possible.
I am trying to create a formula for a cell linking to another sheet as follows:
Results!A1: Text1
Results!A2: Text2
Results!A3: Text3
Results!A4: Text4
If all four cells contain a value, display the value here.
This would allow me to have four corresponding cells showing the values from the results sheet, but only once all four values are entered.
The formula I tried was:
=IF(COUNT(Results!A1:A4)<4,"",(Results!A1))
The cell is showing nothing at all.
Is there anything I can do?
Bookmarks