data validation using formula result

[jpzachar]

Hello....hope you can help....thanks in advance!

I have a formula which is =COUNTIF(C100:M100,<>0). I want to show an error
message box when the result of this formula equals greater then 5. Is this
possible? The formula is in cell N:100

thanks,
Jeff

 

[ShaneDevenshire]

Hi,

Try this

=IF(COUNTIF(C100:M100,"<>0")>=5,"Error",COUNTIF(C100:M100,"<>0"))


if this helps, please click the Yes button

 

[jpzachar]

Thanks Shane.....is it possible to do this using data validation so that I
can use an error message box?

thanks in advance!