Excel Auto Filter Problem

  • Thread starter Thread starter tipoo
  • Start date Start date
T

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
 
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
 
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.
 
Back
Top