countif function

E

etan

Hey there folks. I am wondering how to state the criteria in the COUNTIF
function to find values higher than one number and lower than another. Thank
you.
 
J

JE McGimpsey

One way:

=SUMPRODUCT(--(A1:A10>2),--(A1:A10<10))

another

=COUNTIF(A1:A10>2) - COUNTIF(A1:A10<=10)
 
J

JE McGimpsey

No,

=COUNTIF(A1:A10,">2") - COUNTIF(A1:A10,">=10")

is what I meant. But yours was closer than mine.
 
A

Aladin Akyurek

Funny, since I started to use Thunderbird as mail-client and
news-reader, which is just great, I'm constantly missing a letter or two
in my typing. A great excuse no? <g>

I actually wanted to write about the CountIf idiom that it's faster than
the equivalent SumProduct formula. That is, whenever a numerical
in-between condition is involved, it wouldn't a bad idea to invoke this
CountIf idiom. And SumIf for summing...
 

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

Conditional Formatting based on active Named Range; IF Function to VBA 1
countifs Function not giving desired result with date criteria 2
Excel Countif Function - Calculating Between Two Sets of Values 3
Finding the weighted average of text that have been given values 1
Using the list form control: multi-selection possible? 3
Can we use outlook calendar as an universal place post work schedules for all the users? 0
Formula to answer YES or No 4
COUNTIFS (the numbers in a column, when subtracted meet a certain criteria) 1

Top