Sum Values in a Column if other columns starst with 2 possibilities {"ND"."0%"}

[drom]

Hi and thanks in advance

I have to columns names eg:

• A2:A50 = ColAAA
• B2:B50 = ColBBB

Both names ranges are dinamic anyway for my query does not matter

I would like to SUM the values in ColBBB if the cells in CoaAAA starts with possibilities:

• ND
• 0%

If I use this Formula:
=SUMPRODUCT(--(LEFT(ColAAA)={"ND","0%"})) I get 143

• So actually 143 rows contain ND or 0%
• If I filter on the row Source ColBBB I get a Sum 45000 after this filter

but when using:
=SUMPRODUCT(--(LEFT(ColAAA ,2)={"ND","0%"}),ColBBB )
I get a error
What am I doing wrong?

ps: in this Eg I only put two possibilities , In my job I have many posssibilities
This is why I can't use Sumproduct + SumProduct...

 

[mart37]

=SUMPRODUCT((LEFT(AColAAA;2)={"ND"\"0%"})*ColBBB)