Excel count if sheet name matches with Column E with cell value

[Jyotirmaya]

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 ORANGE" still it shows #REF!, what should be the solution ??

 

[Marc L]

B1=COUNTIF(INDIRECT("'"&A1&"'!E:E"),"<>")-1