Using An Error Log

Question

Hi All, So I created an Error log, I just went through ~230 OG book problems, with error log writing Correct, Wrong, Tricky all in an Excel. My question was how did you sum up which type of questions you got wrong the most? I.e. Geometry, Number Prop, etc etc Can't seem to think of an excel function to solve it. Col 1 has type of problem, col 2 has if I got it right or wrong. Thanks in advance!

Answer 1

Here’s an approach without using formulas:

1) filter the data on column 2, keeping only “wrong” records

2) sort the data by column 1 (major)

3) Subtotal on every change in column 1

This should give you the count of wrongs for each problem type.