count the occurrences of text

hi Elainefish. perhaps you could tell us what's the problem? i did your formula & it returned 14 counts. i counted manually & there are indeed 14 entries that contains 8.1. note that putting the asterisk will include:
18.1
8.11

so if it's wrong, what do you want to show? if you're supposed to do it in another sheet, then put the sheet reference like:
=COUNTIF(Reports!B4:B45,"*8.1*")

if you are supposed to count the entries in "Summary_turbine issues" based on column A, then in B4:
=COUNTIF(Reports!$B$4:$B$46,A4)