Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Countif across multiple non-adjacent cells
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problems comparing data from multiple blank cells | Excel Worksheet Functions | |||
count 2 nonblank cells on multiple worksheets | Excel Discussion (Misc queries) | |||
link multiple cells to multiple cells | Excel Discussion (Misc queries) | |||
link multiple cells to multiple cells | Excel Discussion (Misc queries) | |||
Adding separate accumulators for multiple cells | New Users to Excel |