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

"tipoo" wrote in message
...
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

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.

"John" wrote:

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" wrote in message
...
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