Countif / and

M

Maxwell

Hello,

Here is my problem...

I need a formula to do the following...
=Countif a range (A1:Z1) that is greater than zero and
less than 100. Basically I need to count everything
between 0-100. If the number is either 0 or 100, then it
will not count it.

Please help?
 

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

Excel Countif Function - Calculating Between Two Sets of Values 3
Multiple arguments 3
COUNTIFS (the numbers in a column, when subtracted meet a certain criteria) 1
Using <= in countifs statement 1
Excel 2010 countifs for date range 3
Count Number of Unique Cells That Don't Have Certain Characters 0
Countifs bites again 4
COUNTIF for 2 columns 7

Top