data validation using formula result

J

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
 
S

ShaneDevenshire

Hi,

Try this

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


if this helps, please click the Yes button
 
J

jpzachar

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

thanks in advance!
 
Top