CODEWITHSUNDEEP
excel
Nuttapong Phunsub
Nuttapong Phunsub

Reputation: 25

My sumif sum wrong value

https://docs.google.com/spreadsheets/d/1-UxDz2ZmU7GZumCZ-H2SxWeuczgsAUdAamIp46iXZ_4/edit#gid=0

Please See my sheet from the link

In column J,L,N,P,R Value is wrong

But the problem is 000 and 00 is not the same text but it sum as it same how do i fix this solution.

Upvotes: 0

Views: 607

Answers (2)

TehJake
TehJake

Reputation: 121

You need to convert your values in Column A to text. Either prepend an apostrophe to value in the column (e.g. 01 = '01, 1 = '1), which will tell excel that it is to treat the values as strings, or alternatively, you can try changing the data type of the column to text using the dropdown list in the ribbon.

If you go with the first solution, a quick way is to use this formula and drag it down the column:

="'"&A1

Then copy and paste the results as values over your original column.

Hope this helps.

Upvotes: 1

Kyle
Kyle

Reputation: 2545

Anywhere you have 001 and want it to NOT be summed, put an apostrophe in front of it '001.

Upvotes: 1

Related Questions