Using a sumif off a text

[AC101]

Need to down load data from our ERP system in text format so the leading zeros will not be dropped. When I run a sumif the formula returns the same results for 1, 001, 0001 and 00001. Is there a way to have the formula to treat the leading 0's as they exist? See attached.

[CARACALLA]

I2=if($h2<>"",sumproduct(($a$2:$a$22780=$h2)*($c$2:$c$22780)),"")

copy down

[MarvinP]

Hi AC101,

Here is another answer and a bit easier. In I2 put this formula and pull down.

Please Login or Register  to view this content.

[wk9128]

cell I2 formula , Drag down

Please Login or Register  to view this content.