SumIF Statment
Hi!
Try this:
E2 = A
E3 = B
E3 = C
etc
=SUMPRODUCT(--(LEFT(A$2:A$9)=E2),B$2:B$9)
Copy down as needed.
Biff
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
|