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.
<tbody>
</tbody>
I need the total of all the "red" "AAB" for the third and fourth columns. And then the total of all the "green" "AAB" and so on...
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.
Activity | Object | SC118 | SCE18 |
ASCS | AAB | 10531.81 | 0 |
ASCS | AAC | 2974.99 | 0 |
ASCS | AAD | 3206.19 | 0 |
ASCS | AAE | 2343.93 | 11.13 |
ASCS Total | 19056.92 | 11.13 | |
CNA1 | AAB | 2895.2 | 0 |
CNA1 | AAC | 833.47 | 0 |
CNA1 | AAD | 941.16 | 0 |
CNA1 | AAE | 1814.48 | 181.83 |
CNA1 Total | 6484.31 | 181.83 |
<tbody>
</tbody>
I need the total of all the "red" "AAB" for the third and fourth columns. And then the total of all the "green" "AAB" and so on...