COUNTIF Function with mulitple criteria?
As long as your ranges are always groups of 10 as you posted
Then..with
A1:A100 containing your list of numbers
Try this:
C1: 0
C2: 10
C3: 20
etc
E1: =SUMPRODUCT(--(INT($A$1:$A$100/10)*10=C1))
Copy that formula down
Is that something you can work with?
***********
Regards,
Ron
XL2002, WinXP
"Corey" wrote:
I'm trying to set up some countif statements that will count the
number of cells within a given range that contain number within a
given range.
Ex. One column has a list of random numbers from 0-100. The next
column will count the number of numbers that fall into a given range.
How many of the cells within the first column contain numbers between
0 and 9? 10 and 19? So on and so forth...
Any help on this would be greatly appreciated.
|