HELP with Count Formula

Woelfe

New Member
I don't know where this brain cramp came from but it is here to stay it seems!

I did this once before, and now for the life of me, I can't recreate it.

Here is what I'm trying to do:

I have a spreadsheet with one worksheet that has my database of students with 6 columns of codes which represent 6 different schools of choice. On another worksheet I have the comprehensive list of codes that exist. I've been trying to count up total number of times my college's code shows up in a particular column.

Can anyone help me with the formula that best fits this scenario?

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.
Book4
ABCDEFGHIJ
1Field1Field2Field3Field4Field5Field6
2AACABBABCCBACABCACAAA0
3BCCABBACAABCACBABCAAC0
4CCACBBCCACCBCAABBAABA0
5CBBBCAAAAABCACAACAABB0
6BABABABBBBBABBAACAABC2
7ABCBACCBAACCAACCCAACA0
8ACB0
9ACC1
10BAB0
11BAC0
12BBA1
13BBB0
14BCA0
15BCC0
16CAA0
17CAB0
18CAC0
19CBA1
20CBB0
21CCA0
22CCB1
23
Sheet1

Sounds a bit like a simple COUNTIF solution unless I have misunderstood.

Under each of the six columns insert the following formula

=COUNTIF(A1:A11,224)

where A1:A11 is the range of cells with the data in and in this example 224 = code for your school.

Hope this helps if not some detail may help me understand.

Ahhh the brain cramp has gone away.

I guess what I was trying to do was the COUNTIF formula, but I tried it three times and it didn't seem to net me anything. I just figured out why.

Thanks for the help on that!!

Replies
0
Views
417
Replies
2
Views
102
Replies
3
Views
201
Replies
2
Views
555
Replies
15
Views
436

1,218,620
Messages
6,143,516
Members
450,492
Latest member
Rusbus1972

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back