FORMULAS

Copper Contributor

Hi All,
I cannot apply this formula =COUNTIFS(D2:M2,“<35”) it gives me arror. 
The following message appears: "The formula contains an error".
I have tried to replace COUNTIFS with CONTA.SE and CONTA.PIU'.SE but nothing changed.
Appeared: #ERROR! in the cell where I was trying to apply the formula above.
Any solution to this issue, please? Thanks! Regards.

1 Reply

@Ingrids650 

You shall use semicolons instead of commas

CONTA.SE(D2:M2; “<35”)