Working with Variables

I'm working on an algorithm/calculator that jumps between pages. I'm not at the beginner level, but I'm not sure how far along the intermediate I stand. I'm fairly good at understanding and applying code or modifying formulas, but I just have to learn what possibilities exist first before doing so (to give an example; I used a dragged out method to write out some formulas in the past until I learned about the IF( command. Now I'm comfortable enough with several If statements within the same cell).

So, to give you an idea of what I'm working on:

Column 1 has the date, not used in calculation
Column 2 has the name, not used in calculation
Column 3 has the % done, first step in calculation
Column 4 has the % necessary, second step in calculation

Column 5 has the % checker, >=.7 is considered valid. So if the value in Column 4 is >=.7, it prints 1.

Column 6 is the classifier, user must input "A" "B" "C" or "D"

Now what what I need to do is to find a way to automate the following process:
If Column 5=1 and Column 6 = "A", then add to total count of "A"
If Column 5=1 and Column 6 = "B", then add to total count of "B"
If Column 5=1 and Column 6 = "C", then add to total count of "C"
If Column 5=1 and Column 6 = "D", then add to total count of "D"

I've already used a dragged out solution that gets the job done:
Column 7 checks if Column 6 is A and if Column 5 is 1, if A then 1, if not then nothing
Column 7 checks if Column 6 is B and if Column 5 is 1, if B then 1, if not then nothing
Column 7 checks if Column 6 is C and if Column 5 is 1, if C then 1, if not then nothing
Column 7 checks if Column 6 is D and if Column 5 is 1, if D then 1, if not then nothing

All of these values are then added to their respective total via a sum format.

Welcome Tim,
maybe try the SUMIF for the first group?

If Column 5=1 and Column 6 = "A", then add to total count of "A"
If Column 5=1 and Column 6 = "B", then add to total count of "B"
If Column 5=1 and Column 6 = "C", then add to total count of "C"
If Column 5=1 and Column 6 = "D", then add to total count of "D"

Let's see...

=SUMIF(Column5,A,???)

How can I add the "A"s together? Wouldn't I have to convert them to a value of 1 first?

EDIT--

I tried out the following:

=SUMIF(O:O,"A",IF("A",1,""))

I got a #VALUE! error

Can you post a working sample file(take out any sensitive data or information before attaching the sample).
I'm sure someone here can figure something out for you.

How about for the A count;
=SUMPRODUCT(--($E$2:$E$1000 = 1),--($F$2:$F$1000= "A"))
modify the "1000" to accomidate your range. Does that work for you?