Formula for counting Exceptions???

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting the Excced occurance... 2
can i use vlookup for this?? 6
Excel formula 5
Counting based on multiple criteria 8
For Mike H.'s reply about my msg Jan 20, 'sumif but also filtering 4
Excel Sumproduct 0
Count with conditions? 8
Count max consecutive cells 2

Back
Top