I need to sum Programs (C6:F88) by color and by object class (B6:B88)
I can do the two separate functions: =SUMPRODUCT(--(LEFT($B$6:$B$88,3)="AAB"),C6:C88) and =sumbycolor(C15,C10:C88) but I can't figure out how I can do both. Pretend my example table had fill colors instead of text color...