Formula for counting Exceptions???

[Guest]

I need some help with developing a formula that will calculate the number of
times a column contains a value that exceeds the allowable limit...

Basicaly I have several Cols of Data (Chemical Concentrations) and I would
like to add a row at the bottome below Total and Average that will show the
number of times the Chemical Conc exceeded the allowable limit.

Anyone have a formula suggestion?

 

[Guest]

=COUNTIF(A2:A200,">" & B1) where B1 is your allowable limit