SumIF Statment
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 |
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 |
All times are GMT +1. The time now is 05:22 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com