Forum Discussion
Issues using Ampersand (&) to combine numbers from two different cells
So, the invoice number is the criteria, right?
Then you can leave it as text but you hit another problem because SUMIF() makes a type conversion from text to number and the result is not correct.
But there is a workaround:
https://newtonexcelbach.com/2017/12/22/the-countif-bug-and-how-to-avoid-it/
Excel display only 15 digits (of precision). Any other digit reverts to 0.
Do you have to do further calculations (adding, subtracting, ...)?
If not then leave it as text. Otherwise you may look for other applications or addins which can handle numbers with more than 15 digits.
- I do need to do further calculations as I am using a SUMIF formula to total the amounts received based on the special invoice number. Do you know of any add one as you suggested?
So, the invoice number is the criteria, right?
Then you can leave it as text but you hit another problem because SUMIF() makes a type conversion from text to number and the result is not correct.
But there is a workaround:
https://newtonexcelbach.com/2017/12/22/the-countif-bug-and-how-to-avoid-it/
Detlef_Lewin That worked perfectly!! Thanks so much for giving that additional resource as I used the CHAR(173)& and it worked like a charm! Have a great day and thanks again!!
