Counting number of times a value appears in a certain cell over multiple sheets

Hi everyone,

Im looking for a formula that can count how many time a certain cell has something entered into it over multiple sheets in the same workbook. the data will be in the same cell in every sheet but will be over hundreds of sheets in the same workbook.

Im playing around with various COUNTIF formulas but cant get it to work.

Any help would be massively appreciated,

Thanks!

One way

=SUMPRODUCT(COUNTIF(INDIRECT("'" &Sheets & "'!B2"),">" &0))

"Sheets" is named range (list) of your sheets

counts number of entries in B2 > 0