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