how to treat this value in a sumif

[Pumpk1n]

I have a field that is "general" which contains a text field with a value is '00000000 ' (8 zeros with a space following). When I try to add the criteria in a 'sumifs,' statement, it is not summing as expected. The formulas I have tried are: =sumifs(h3:h247,c3:c247,"<1") and =sumifs(h3:247,c3:247,"=00000000 ") and =sumifs(h:h247,c3:c247,"=0").

Thanks in advance.

 

[JoeMo]

Try:

=sumifs(h3:247,c3:247,"00000000 ")

 

[BenMiller]

Try:

=sumifs(h3:247,c3:247,"00000000 ")

For some reason, this will return TRUE even if the string does not have the trailing space.

 

[JoeMo]

For some reason, this will return TRUE even if the string does not have the trailing space.

Works for me. Are your "00000000 " entries text?

 

[BenMiller]

Works for me. Are your "00000000 " entries text?

Yes

 

[JoeMo]

Yes

Can you copy this to your workbook?

Excel Workbook
	C	D	E
2	00000000	1	11
3	data	2
4	data	3
5	data	4
6	data	5
7		6
8	data	7
9	data	8
10	data	9
11	00000000	10
Sheet2