Struggling with SUMIF

Hi,
I paste an excel 97 report sheet into sheet1 of an excel 2010 workbook.
In sheet2 I have a list of part numbers in column A and a SUMIF formula in column B.
I have been trying for a while now to get the formula to give a result, but failing miserably.
I have looked at the help in Excel and on here, and the formula looks ok to me, but I'm obviously missing something.
I have attached the workbook in question,
As always, your help is appreciated.
Thanks
Project1.xlsx
LVL 1
Stephen ByromWarehouse/ShippingAsked:
Who is Participating?
 
FlysterConnect With a Mentor Commented:
Here's an alternative using SUMPRODUCT

Flyster
Project1.xlsx
0
 
Stephen ByromWarehouse/ShippingAuthor Commented:
Brilliant!
Thanks for your time
0
 
Stephen ByromWarehouse/ShippingAuthor Commented:
Was SUMIF wrong in this situation then?
0
 
Saqib Husain, SyedEngineerCommented:
The data in column Z is text and not numbers. One way to convert the numbers is to select all numbers in column Z and perform a

Data > Text to columns

on the numbers. This will give the correct results
0
All Courses

From novice to tech pro — start learning today.