SUMIFS/VALUE

Question

Hello,

On sheet A, I have 2 columns (among many others) .

Column1 contains a LEFT-formula that returns 3 digits. Column2 contains a LEFT-formula that returns 3 digits plus a hyphen and then 2 more digits.

On sheet B I have a SUMIFS formula that references sheet A.

If I reference column2, it works. If I reference Column1 it doesn't work unless the LEFT-formula is put inside a Value-formula. I wondering why that is… :-)

/Nikolaj

Paul Newcome · Answer

There can be differences, but it is hard to say without seeing what you are working with to be sure and to try some troubleshooting / testing.

Nikolaj F · Answer

Thank you for answering. I'll try and get a bit more information and maybe access to sheet A. Then I'll follow up here.

I was curious if there are general differences in using SUMIFS when referenced cells contain numbers+txt or just numbers. The SUMIFS is looking for a specific value in quotes.

The formulas in sheet A simply return the 3 left characters or the 6 left characters. Otherwise, should be the same.

/Nikolaj

Paul Newcome · Answer

Are you able to provide screenshots (sample data if needed) for context? Also, what are all of the formula you are using?