sumif not working properly with text

[jordanburch]

Hi All,

I have the below. The sum if is summing based on column f acquierer ref number. It then sums column c if there is a match and gives me the total. The sum if is giving false positives. See below formuls in n and m one sums db column the other cr column based on column f. For whatever reason it is showing it as 43.5 in columns m and N when there should only be a 43.5 in either column m or n but not both. There is only one instance of the acquirer ref number in column f so based on that it should only put one value but its pulling 43.5 for all of those columns m1 through n4. I think it may be becuase its a text in the acquiere ref number but am not sure.
=+SUMIF(F:F,F6260,D:D)

 

[jordanburch]

This is the result of those sum ifss see how its bot 43.5 on both sides that shouldnt be happening

 

[shift-del]

There is only one instance of the acquirer ref number in column f

The count in column O shows 2. There must be another row with the same acquirer ref number.

 

[jordanburch]

The count in column O shows 2. There must be another row with the same acquirer ref number.

That's the crazy things there isn't

 

[Asbestos_Jen]

You could try conditional formatting the cells in question to flag duplicates and see what shows up.

 

[jordanburch]

You could try conditional formatting the cells in question to flag duplicates and see what shows up.
View attachment 108739

Grat idea will try in the am and update

 

[shift-del]

Try this:

Recon.xlsx
	M	N
4	330,30	0,00
Sheet1

Cell Formulas
Range	Formula
M4	M4	=+SUMIF(F:F,CHAR(173)&F4,C:C)
N4	N4	=+SUMIF(F:F,CHAR(173)&F4,D:D)

 

[jordanburch]

Try this:

Recon.xlsx
	M	N
4	330,30	0,00
Sheet1

Cell Formulas
Range	Formula
M4	M4	=+SUMIF(F:F,CHAR(173)&F4,C:C)
N4	N4	=+SUMIF(F:F,CHAR(173)&F4,D:D)

Will try in the am thank you so much for your suggestions

 

[jordanburch]

You could try conditional formatting the cells in question to flag duplicates and see what shows up.
View attachment 108739

ok I tried this and it shows them all as duplicates even though they are not its strange to me

 

[jordanburch]

Try this:

Recon.xlsx
	M	N
4	330,30	0,00
Sheet1

Cell Formulas
Range	Formula
M4	M4	=+SUMIF(F:F,CHAR(173)&F4,C:C)
N4	N4	=+SUMIF(F:F,CHAR(173)&F4,D:D)

this worked thanks@! what is it actually doing though?