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.
Bookmarks