On my 'Hosts' tab in my spreadsheet, this formula:    =COUNTIF( Sites.$N$3:$N$185 ; $A2 ) worked fine up until now, where it's only returning #NULL!. The range in question on the 'Sites' tab is correct; I've quadruple checked that N3 is where my data starts and N185 is where it ends.

I have a strong feeling that this is a problem on Zoho's side but would love any tips.