Sample Data in Result Sheet

I have a formula in A2 that extracts data & splits it into unit & product (A & B). I used the SUMIF formula to give the the total of each separate set of product from A, but got value 0.

So then I converted the COl A into values in Col. C, and using sum if on that gives me the correct total.

Why can't I get the correct sum directly from A?

enter image description here

  • 2
    As you will surely have already understood, the answer to your question is: because column A contains texts and not numbers. In fact, you would like to add something very similar to: a + a + c + b ... not containing any number, the result is 0
    – Daniele
    Jun 20, 2022 at 0:47


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.