Excel Auto Filter Problem

[tipoo]

Hi,

I have three columns. Column A and B have data and column C has a unique
numeric digit that I use the autofilter to pick up data in column A and B.

Without filetering data total is same but when I select unique digit from
column C then Column A and B total changes. I have auto-filter on all column.

Any help would be appreciated.

Thanks

Tipoo

 

[John]

What do you mean, "...has a unique numeric digit that I use the autofilter
to pick up data in column A and B"? Are you testing C, and if C meets the
test, the data is not filtered, but is displayed and you want it included in
your totals?

John

 

[tipoo]

Hi John,

I have manually populated that unique number just to filter column A and B
data and I have a row that shows the total column A and B.