Spreadsheet: 804038d1667853236-conditional-formatting-formula-multiple-criteria-sum-count-exemption-exception-sample_workbook
Sheet: SAMPLE

INITIALS | CANDY BAR | BRAND | SOLD | VERIFY | COMMENTS
EC | A | A | 47 | DONE
LP | A | AA | 190
JT | AA | AA | 67 | DONE | ???
 | AB | AA | 51
 | AC | AA | 62
 | AD | AA | 50
 | AE | AA | 57
 | AF | AA | 52
 | AG | AA | 190
 | AH | AA | 51
 | AI | AA | 47
 | AJ | AA | 59
 | AK | AA | 52
 | AL | AA | 67
 | AM | AA | 46
 | AN | AA | 55
[NAME] | AO | AA | 95 |  | Worst Candy EVER
 | AP | AA | 48
LP | B | AA | 58
RM | C | AA | 55 | DONE | NOT
 | D | AA | 67
 | E | AA | 48
 | F | AA | 50
 | G | AA | 66
 | H | AA | 50
SS | I | AA | 64 | DONE | TO
 | J | AA | 52
JM | K | AA | 80
 | L | AA | 45
 | M | AA | 72
 | N | AA | 55
JT | O | AA | 71 | DONE
JT | P | AA | 46 | DONE
JT | Q | AA | 53 | DONE
mk | R | AA | 85 | DONE
mk | S | AA | 71 | DONE
mk | T | AA | 55 | DONE
mk | U | AA | 59
SS | V | AA | 47 | DONE
 | W | AA | 78
 | X | AA | 57
 | Y | AA | 47
RM | Z | AA | 77 | DONE | BE
 | A | AB | 62
AD | AP | AB | 44 | DONE
 | B | AC | 56
RM | C | AD | 45 | DONE
 | D | AE | 58
JB | E | AF | 60
JB | F | AF | 82
 | G | AG | 49
[NAME] | B | B | 57
[NAME] | C | C | 47 | done
mk | D | C | 50 | DONE
EC | E | C | 45 | DONE
AA | F | C | 46 | DONE
[NAME] | G | C | 49 | DONE
AA | H | C | 52 | DONE
EC | I | D | 47 | DONE
TS | J | E | 47 | DONE
TS | K | E | 59 | DONE
SK | L | E | 72 | DONE
SK | M | E | 45 | DONE
SK | N | E | 54 | DONE
SK | O | E | 59 | DONE
mk | P | E | 58 | DONE
LW | Q | E | 50 | DONE
LW | R | E | 45 | DONE
RM | S | F | 55 | DONE | Very good
RM | T | F | 44 | DONE
[NAME] | U | G | 45
 | AA | H | 47 | DONE
JB | AB | H | 69 | DONE
el | AC | H | 47 | DONE
el | AD | H | 61 | DONE
mk | AE | H | 62 | DONE
mk | AF | H | 77 | DONE
LP | AG | H | 65 | DONE
AD | AH | H | 44 | DONE
AA | V | H | 59
SK | W | H | 76 | DONE
JB | X | H | 77 | DONE
el | Y | H | 51
SS | Z | H | 61 | DONE
EC | AI | I | 46 | DONE
EC | AJ | I | 59 | DONE
EC | AK | I | 47 | DONE
RM | AL | J | 46 | DONE
JJ | AM | J | 49 | DONE
JJ | AN | J | 46 | DONE
RM | AO | J | 46 | DONE
 | AP | K | 52 | DONE
 | A | L | 47
CC | B | L | 46 | DONE
CC | C | L | 49 | DONE
CC | D | L | 45
CC | E | L | 49
EC | F | M | 45 | DONE
EC | G | M | 60 | DONE
 | H | M | 55
 | I | M | 48
 | J | M | 45
 | K | M | 52
DG | L | N | 47 |  | Not so GOOD
DG | M | N | 46
JB | N | O | 46 | DONE
JT | O | O | 51 | DONE
JT | P | O | 51 | DONE
JT | Q | O | 44 | DONE
JT | R | O | 48 | DONE
 | S | O | 44
JB | T | O | 48 | DONE
el | U | O | 44 | DONE
el | V | O | 44 | DONE
JT | W | O | 45 | DONE
JT | X | O | 209 |  | Unsure of pruchase
JT | Y | O | 47 | DONE
JB | AA | P | 50 | DONE
JB | Z | P | 53 | DONE
JB | AB | Q | 46 | DONE
JB | AC | R | 54 | DONE
SS | AD | S | 66 | DONE | Help
mk | AE | S | 48 | DONE
SK | AF | S | 51 | DONE
DV | AG | S | 58 | DONE
SK | AH | S | 59 | DONE
DV | AI | S | 55 | DONE
DV | AJ | T | 52 | DONE
SK | A | U | 52
JM | AK | U | 63
 | AL | U | 45
SS | AM | U | 51
DV | AN | U | 74
DV | AO | U | 46 | DONE
SK | AP | U | 47
SS | B | U | 59 | DONE | DONE
el | C | U | 64 | DONE
JM | D | U | 78
DV | E | U | 58 | DONE
DV | F | U | 60 | DONE
DV | G | U | 44 | DONE
EC | H | V | 66 | DONE
EC | I | V | 44 | DONE
EC | J | V | 59 | DONE
mk | K | W | 53 | DONE
mk | L | W | 62 | DONE
mk | M | W | 72 | DONE
mk | N | W | 52 | DONE
el | O | W | 58 | DONE
JJ | P | W | 45
 | Q | W | 63
 | R | W | 47
 | S | W | 82
 | AA | X | 76
 | AB | X | 51
 | AC | X | 49
MW | AD | X | 62 | DONE
MW | AE | X | 82
 | AF | X | 45
RM | AG | X | 52
RM | AH | X | 46
RM | AI | X | 54 | DONE | TO
MW | AJ | X | 65 | DONE
LW | T | X | 45 | DONE
LW | U | X | 50 | DONE | WHO
RM | V | X | 96 | DONE | WHEN
LW | W | X | 62 |  | WHERE
RM | X | X | 48 | DONE
RM | Y | X | 50 | DONE
 | Z | X | 60
RM | AK | Y | 57 | DONE | BE
RM | AL | Y | 63 | DONE | OR
AD | AM | Y | 50 | DONE
el | AN | Y | 85 | DONE
MW | AO | Z | 47