HELP with Count Formula

Woelfe

New Member
Joined
Sep 17, 2002
Messages
35
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?

Thanks in advance!!
 

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.
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
 
Upvote 0
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.
 
Upvote 0
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!!
 
Upvote 0

Forum statistics

Threads
1,213,535
Messages
6,114,198
Members
448,554
Latest member
Gleisner2

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top