• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 340
  • Last Modified:

Struggling with SUMIF

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.
Stephen Byrom
Stephen Byrom
  • 2
1 Solution
Here's an alternative using SUMPRODUCT

Stephen ByromWarehouse/ShippingAuthor Commented:
Thanks for your time
Stephen ByromWarehouse/ShippingAuthor Commented:
Was SUMIF wrong in this situation then?
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now