WORSHIP

COLUNA E=
PROCV(D3;$C$13:$D$14;2)

COLUNA F=
PROCV(B3;$E$13:$F$14;2)

COLUNA B=
SOMASE(B3:B10;"B";C3:C10)

COLUNA C=
SOMASE(B3:B10;"b";C3:C10)