1

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

Improve this question
1
  • 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

0

Reset to default

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.