Hi all so I am using the countif function to count the number of times a specific string appears in a spreadsheet. This formula works for 436 values out of 803 however for the remaining values it returns #VALUE!. Is there a way to fix this behaviour? the formula I use is
=COUNTIF(Table16[@[SRR accession]]:'BLASTx of viral contigs'!R1542,[@[SRR accession]])
