Need Help on formal - output a sum

  • Thread starter Thread starter Deiow
  • Start date Start date
D

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
 
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)
 
Thanks T. Valko, appreciated your help, the formal is working wonderfull.
Very happy now, no more manual calculation

Thanks Again Deiow
 
Back
Top