Values in AutoFilter are not adding up. Some values are not even appearing in the AutoFilter.

[Excel_VBA]

I have 2 unusual situationS involving AutoFilters. I have many values listed in the AutoFilter.

1. I will deselect the very first value in one column then add the sum of the remaining values and get a number (A). Then I will select only the first value and deselect the other values and take the sum (B). Both of these values (A and B) should add up to the same value that you get when you select all items in the AutoFilter, but they do not. Any idea why?

2. I noticed one particular value in the dataset that does not appear in the AutoFilter list. I am thinking this might have something to do with the problem. Why would a value not appear in the AutoFilter list?

 

[repairman615]

Hello,

Could it be that the value is text and not a number?

 

[Excel_VBA]

Hello,

Could it be that the value is text and not a number?

The values in the AutoFilter I am selecting for are descriptions. They are formatted as general. The values I am adding in another column are formatted as Accounting. So it doesn't look like it's a formatting issue. I appreciate the suggestion. Any other ideas?

 

[repairman615]

Maybe try this formula as a test:

=ISTEXT(D2)

Where D2 is the first entry of the column. Then fill down untill the end of your list. Dealing with numbers, all should return false.

 

[Excel_VBA]

Maybe try this formula as a test:

=ISTEXT(D2)

Where D2 is the first entry of the column. Then fill down untill the end of your list. Dealing with numbers, all should return false.

I tried your suggestion. It didn't work. When I deselect the first value and keep all remaining values, it's as if some values are being filtered out in addition to the first value I am deselecting.

I checked below my data set to see if there are any other occurrences of the deselected data and there are none.

Did you see my other question about a pivot table? Any ideas about that one?