COUNTIF Formula question

[honkymagoo2009]

Hello,
I have a largw block of cells that I need to count a wide range of numbers. I seem to have issue copying the COUNTIF formula sequentially into the column.
=COUNTIF(C:G,1)
and then I would hope to continue the formula onward from 1 to 75. I have tried to copy the formula via copy and paste, dragging the black crosshair, creating 2 seperate formulas then highlighting the said cells and dragging black crosshair. Nothing seems to work. I have a SUM formula in a separate column that copies sequentially perfectly. So Im confused as to why the COUNTIF will not copy sequentially?

 

[Dave Patton]

Your question is not clear.

Consider the alternatives shown and/or provide several examples of your sheet's information.

T202209a.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L
1
2			1	6		3		1	1	1	1	1
3					10	2	2	2	2	2	2	2
4								1	1	1	3	3
5											4	4
6											5	5
6c

Cell Formulas
Range	Formula
H2:H4	H2	=COUNTIF(C:G,ROW()-1)
I2:I4	I2	=COUNTIF(C:G,K2)
J2:J4	J2	=COUNTIF(C:G,L2)
L2:L76	L2	=SEQUENCE(75,1,1,1)
Dynamic array formulas.

 

[honkymagoo2009]

Here is the basic layout Ive started. in H2 I would like to put the COUNTIF formula. Columns C to G are the cells I want to count how many times the numbers from 1 to 75 appear in the columns C,D,E,F, and G.
The second Image has "show formulas" on, and how I would like formula to copy. From 1 down to 75. Much like I was able to copy the SUM formula to the right.
Am I wrong in doing it this way?
I'm really new to Excel, I'm still learning alot of the ins and outs of it.
if all else fails I'll just copy and then change each single line all the way down.

Thanks for any and all help.

 

[Dave Patton]

Try one of the 4 alternatives shown previously or try

COUNTIF(C:G,ROW(A1)) and fill down.

 

[honkymagoo2009]

Try one of the 4 alternatives shown previously or try

COUNTIF(C:G,ROW(A1)) and fill down.

Thank you...but, Im not using any information from row A1, column A plays no part in what I am trying to count.

All of the data has not been entered yet. I am still building the sheet.

I am hoping to find the frequency in which the number from columns C to G. In the entire columns C to G there will be number entered in the cells. 1 to 75. Once all of the data is entered. I want to find out how frequently those numbers appear in those columns.

As an example,with the data shown in the images above, I want to know how many times the number 22 appear In the entire columns of C to G. =COUNTIF(C:G,22) Using 22 as the example, with the data that is shown, the formula should return a result of 2. If we use the example of the number 12, with the given data above, the result should be 4.

I think I am using the wrong formula for what i am trying to do.
Atleast, in the way to have it copy fill. It gives me the result I am looking for, I was just hoping to not have to change every line 75 times.

 

[Dave Patton]

Each of the suggestions provide the answers that you specified.
You can paste my post into a clean sheet and then review the information with Formulas Evaluate Formula.
Click on the icon below the f(x) in the heading and then move to your sheet and paste.

T202209a.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M
1								Countif increment
2			32	34	12	19	22	1	1	1	1	1	1
3			9	11	27	45	1	0	0	0	0	2	2
4			12	34	65	72	12	0	0	0	0	3	3
5			69	71	12	22	43	5	5	5	5	4	4
6			4	4	4	4	4	0	0	0	0	5	5
7								0	0	0	0	6	6
8								0	0	0	0	7	7
9								0	0	0	0	8	8
10								1	1	1	1	9	9
11								0	0	0	0	10	10
12								1	1	1	1	11	11
13								4	4	4	4	12	12
14								0	0	0	0	13	13
15								0	0	0	0	14	14
16								0	0	0	0	15	15
17								0	0	0	0	16	16
18								0	0	0	0	17	17
19								0	0	0	0	18	18
20								1	1	1	1	19	19
21								0	0	0	0	20	20
22								0	0	0	0	21	21
23								2	2	2	2	22	22
6c

Cell Formulas
Range	Formula
H2:H23	H2	=COUNTIF(C:G,ROW()-1)
I2:I23	I2	=COUNTIF(C:G,ROW(A1))
J2:J23	J2	=COUNTIF(C:G,L2)
K2:K23	K2	=COUNTIF(C:G,M2)
M2:M76	M2	=SEQUENCE(75,1,1,1)
Dynamic array formulas.