Need Help on formal - output a sum

[Deiow]

Hello All,

I need help, I have 2 columns, all the first digits in Hex/Code column
(0,1,2) and (6,7,8) then calculate the sum of the size, for example, in A2,
A3, A4 and A8 has first digit of (0,1,2) then we calculate the sum of size
B2,B3,B4 and B8 is 170

Also for (6,7,8) we do the same and the total size for (6,7,8) is 311

Hex/Code size(GB)
0034 45
1101 35
20A1 34
630C 98
7034 101
8145 23
2000 56
6123 89

Thanks in advance all, Deiow

 

[T. Valko]

Assuming that your hex codes are text strings:

=SUMPRODUCT((LEFT(A2:A9)={"0","1","2"})*B2:B9)

=SUMPRODUCT((LEFT(A2:A9)={"6","7","8"})*B2:B9)

 

[Deiow]

Thanks T. Valko, appreciated your help, the formal is working wonderfull.
Very happy now, no more manual calculation

Thanks Again Deiow

 

[T. Valko]

You're welcome. Thanks for the feedback!