Need Help on formal - output a sum
 

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

Need Help on formal - output a sum
 

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)

--
Biff
Microsoft Excel MVP


"Deiow" wrote in message
...
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

Need Help on formal - output a sum
 

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

Thanks Again Deiow

"T. Valko" wrote:

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)

--
Biff
Microsoft Excel MVP


"Deiow" wrote in message
...
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

Need Help on formal - output a sum
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


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

Thanks Again Deiow

"T. Valko" wrote:

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)

--
Biff
Microsoft Excel MVP


"Deiow" wrote in message
...
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