[Solved] Calculate a Generator Matrix with VBA [closed]

Sounds like you just need a countifs formula, so the yellow cell would have:

=COUNTIFS($B$2:$B$10001,”AAA”,$C$2:$C$10001, “AA”)