Countif function counts blanks

The current countif function is matching and counting a code from the multiple sheets and returning the total value. However, if there is no code in 'sheet RE' A13 the formula will count all blank cells and return the total number of blank cells.

Is there a way I can subtract the total amount of blank cells from my current formula to return 0?

This is the following formula found on the RE sheet:

=SUM(COUNTIF(INDIRECT("S"&{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27}&"!C1:C135"),"="&Table210[[#This Row],[ID]]))

Comment Bank 1.xlsx