Formula range #Value! error

[Grammarjunkie]

Normally when I write formulas, I have no need for ranges. But in this case, I need L10:L75.

=IF(L10:L75="","blahblah","blahblahblah")

Doing it individually doesn't return a #value! error, but doing the range does. As someone who has never needed a range before, I'm not sure if I'm doing something wrong or if I'm missing something entirely.

Would anyone mind helping me fix the value error. I don't want to do an =IF(AND for every single cell L10 through L75 haha.

Thanks in advance.

 

[Grammarjunkie]

You're welcome.

Here's another way

=IF(SUM(COUNTIF(L10:L75,{"?*","<=9.99999999999999E+307"})),"at least 1 non blank","All are blank")

Iiiiiiiiii.. don't like that one as much. :P