Dan wrote...
Now this doesn't help me at all because it looses the zeros, i need the zeros
there because 005 is unique format, because there is a 005 0005 and just 5,
so i have to able to tell which value it is.
....
"Dan" wrote:
I have a huge excel sheet with 25000 lines it, i am using the following sum
if function: =SUM(IF(make!$A$2:$A$9571=finally!C1270,make!$C$2: $C$9571,0),0)
entered with Ctrl+Shift+Enter.
....

Replace the function above with

=SUMIF(make!$A$2:$A$9571,finally!C1270,make!$C$2:$ C$9571)