apply countif formula acorss multiple worksheets

Hi

I'm really struggling with an earlier macro and not understanding why macro is not working, so will have to create a workaround.

I need to apply a countif formula to count the number of blank rows in a range B16 to B22 and return the count in cell B1 in each worksheet. There will be numerous worksheets in each workbook.

Is this easy to do?

many thanks

Gary