S
Shu of AZ
The data is contained in Q5:Q300.
This is the pattern of the data and the pattern where the numbers are
concerned are random numbers between 0 and 6. ex. Q5=2,
Q6=4,Q7=1,Q8=""(blank cell),Q9=1,Q10=0,Q11=2,Q12=""(blank cell). . .
This pattern continues throughout the colum, number,number,number,blank
cell, number,number,number,blank cell and continues to repeat and updated
causing the rows in column to increase.
The problem is I have to be able to count (not sum) how many 0's, 1's, 2's,
3's, 4's, 5's, and 6's there are but have to count them in the first cell of
all paterns, the second cell of the patterns and the third cell of the
patterns.
So, in basic explanation, I need to know how many 1's there are in Q5, Q9,
Q13 and so on and then count how many 4's there are in Q6, Q10, Q14 but
never all cells in the column like a sum would be. I tried fooling it by
using SUM and then dividing by the number I needed to find out the amount of
until I realized SUM only allowed 30.
Thanks
Countif does not allow you to do anything other than ranges? Is there
another way?
This is the pattern of the data and the pattern where the numbers are
concerned are random numbers between 0 and 6. ex. Q5=2,
Q6=4,Q7=1,Q8=""(blank cell),Q9=1,Q10=0,Q11=2,Q12=""(blank cell). . .
This pattern continues throughout the colum, number,number,number,blank
cell, number,number,number,blank cell and continues to repeat and updated
causing the rows in column to increase.
The problem is I have to be able to count (not sum) how many 0's, 1's, 2's,
3's, 4's, 5's, and 6's there are but have to count them in the first cell of
all paterns, the second cell of the patterns and the third cell of the
patterns.
So, in basic explanation, I need to know how many 1's there are in Q5, Q9,
Q13 and so on and then count how many 4's there are in Q6, Q10, Q14 but
never all cells in the column like a sum would be. I tried fooling it by
using SUM and then dividing by the number I needed to find out the amount of
until I realized SUM only allowed 30.
Thanks
Countif does not allow you to do anything other than ranges? Is there
another way?