I am using the formula
B1=COUNTIF(INDIRECT(A1&"!E:E"),"<>")-1
But when there is space in between in Column A then I am getting error as #REF!, for example when I have cell value as "REDORANGE" its showing value but when I am using "RED ORANGE" its showing #REF! and my sheet name is "RED...