SUM BASE ON FIRST NUMBER OF NUMBER WITH IGNORING BLANK CELLS IN RANGE

[askall1000]

Hi,

Can anybody help me, i am trying to sum numbers base on their first numbers, i find a formula in the forum and when tried it, it gave value error because of blank cell but i tried to modified but couldn't overcome, any help will appreciated.

 

[Habtest]

It works with one tweak on the condition argument

Book1
	A	B
1
2	652	1,000
3	689	750
4		250
5	256	3,500
6	690	4,000
7
8		5,750
Sheet1

Cell Formulas
Range	Formula
B8	B8	=SUMPRODUCT(--(LEFT(A2:A6,1)="6")*(B2:B6))

 

[askall1000]

Thank you very much, it worked.