ExcelBanter - Formula for counting Exceptions???

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formula for counting Exceptions??? (https://www.excelbanter.com/excel-discussion-misc-queries/147882-formula-counting-exceptions.html)

Will

Formula for counting Exceptions???

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?

Toppers

Formula for counting Exceptions???

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

"Will" wrote:

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?

All times are GMT +1. The time now is 08:35 PM.