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.

Here is an example of the problem:

PART# VALUE
A1. 025 B1. (THIS IS WHERE THE ABOVE FORMULA IS ENTERED)

The value in B1 does not want to display unless i go into A1 as if i were
editing it and then, once the cursor starts blinking i just simply push ENTER
to confirm the value in A1 and that is when the value in B1 appears. The
values in the a coloumn A were imported as text because the first digit is a
zero and if imported as general or as a number it looses the zero. I tried
formating afterwards the cell value from text to number and it still doesn't
work unless I manually go in and then push enter. There is so many parts it
would take me days to go into each cell and push enter.

Any help is appreciated.

Much thanks in advance!