Mar 01 2021 11:07 AM
See below for examples:
- How would I write a formula to count the number of occurrences where the Group and Common fields have the same value?
- If Group is blank, output the number of occurrences using only using Common field only
Group | Common | |
ABC | Hello | 3 |
ABC | Hello | 3 |
ABC | Hello | 3 |
EFG | Bye Bye | 1 |
Ola | 1 | |
CCC | EEE | 1 |
DDD | FFF | 2 |
DDD | FFF | 2 |
Mar 01 2021 11:12 AM
In C2:
=IF(A2="",COUNTIF($B$2:$B$9,B2),COUNTIFS($A$2:$A$9,A2,$B$2:$B$9,B2))
Adjust the ranges as needed, then fill down.
Mar 01 2021 11:33 AM