=SUMPRODUCT(--(LEFT($A$2:$A$20,1)="A"),$B$2:$B$20)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Rashid" wrote in message
ups.com...
Hi to All.

How would i write a sumif statment using the first character (left
function) of WH range to pull the data into the Final Values

original LIST
WH VALUE
A4 15,000
A6 6,500
B4 -313,079
BZ 20,000
C4 -335,343
D4 -393,476
H3 500,000
H4 3,200,000

FINAL VALUES - sumif
WH VALUE
A 21,500
B -293,097
C -335,343
D -393,476
H 3,700,000


Thanks,

Rashid