COUNTIF less than a number

[bwat2435]

Hi All,

I have a dataset and I'd like to make a column which would have the equivalent excel formula =COUNTIF(A2:f2, "<30")

I've fiddled for a while and can't figure it out. Does anyone have any ideas? 

I have attached the spreadsheet if that helps.

Thanks in advance!

[OllieClarke · Accepted solution]

Hi @bwat2435 here's a way of doing it:

[bwat2435]

Thank you Ollie! worked a treat 🙂