Notifications
Clear all
Topic starter
Can someone help please, this is probably pretty simple however my knowledge is fairly basic.
At the moment there are no values in cells H6-H20, I would like cell H21 to remain blank unless a value is entered into any of the cells within the H6-20 range, once a value has been entered within the H6-H20 range I would like cell H21 to return the text POA. I have attempted below however does not work and returns a spill error.
=IF(H6="","",IF(H6:H20>0,"POA",""))
thanks in advance
Posted : 11/01/2021 5:42 am
Topic starter
its ok I have worked it out as =IF(COUNT(H6:H20),"POA"," ")
Posted : 11/01/2021 6:24 am
Possibly you can use COUNTA() instead of COUNT()
COUNTA() can handle text, numbers etc.
Posted : 11/01/2021 7:00 am