Is there a formula that could total Freq number found in column B but only when the values in column A are the same?
Attached is an example of what the formula would output.
A | B | C | D |
Location | Freq | Freq | Level |
AAA | 1 | Grew | |
AAA | 1 | Grew | |
AAA | 1 | Shrunk | |
BBB | 1 | Grew | |
BBB | 1 | Shrunk | |
BBB | 1 | Grew | |
CCC | 1 | Grew | |
CCC | 1 | Shrunk | |
CCC | 1 | Grew | |
CCC | 1 | Grew | |
CCC | 1 | 1 | No Change |
Attached is an example of what the formula would output.
A | B | C | D | E |
Location | Freq | Freq | Level | Level Increase |
AAA | 1 | Grew | ||
AAA | 1 | Grew | ||
AAA | 1 | Shrunk | 2 | |
BBB | 1 | Grew | ||
BBB | 1 | Shrunk | ||
BBB | 1 | Grew | 2 | |
CCC | 1 | Grew | ||
CCC | 1 | Shrunk | ||
CCC | 1 | Grew | ||
CCC | 1 | Grew | ||
CCC | 1 | 1 | No Change | 4 |