Find and Count?

[grcd]

excel_example.png

So, I have a question: I have a document in which various essays marked are assigned to a 'Mark Band' (e.g. 40-50%, 50-60%, etc.). I would like Excel to look through the 'Mark Band' column, and whenever it finds what I am looking for, increment a counter by +1.

For example, in this picture, there are Mark Bands ranging from 1 to 5. What I would like to do is create 5 separate fields, one for telling me how many '1's were found, one for the '2's, and so forth.

I thought it would be as simple as telling Excel through the IF command to add 1 (+1) (ie =IF(D5:D18=1,1,0) where whenever '1' is found, Excel adds 1 to the counter, otherwise does nothing).

Can someone help me fix this formula? I am aware of basic formulas and commands, but for the most part I have never had to do something involving more complex logic.

[ChemistB]

If your mark bands are in column B

=COUNTIF(B:B, 1) returns a count of all 1's. Is that what you are looking for?

[Sam Capricci]

sounds like you want a countif formula, something like =COUNTIF(B:B,"1") if they show up as text or =COUNTIF(B:B,1) if they are numbers. or =COUNTIF(B:B,D1) if you put the reference like 1 or 2 etc in cell D1.

[grcd]

Yes, both of you helped me a lot here! I was confused because I was trying to make this work with the IF function, and I did not know exactly how to use COUNTIF. Many thanks!

[Sam Capricci]

Glad we could help. If that takes care of your issue don't forget to mark the post as solved using the thread tools dropdown at the top of the post.

Oh, and thanks for the rep!

[grcd]

No worries! Thank you for being such lifesavers! I would have spend hours trying to figure out a solution using IF