Filters To Delete Stuff?

Hi Guys,

I have a column which I used FIlters to exclude countries I didn't want.

Now I would like to remove those countries data completely. Is there anyway I can use FIlters to perm delete data I don't want?

Or any other method?

Cheers,

TD

I tried that, but my TOTAL at the bottom keeps distorting when I do this.

I have set up filters to exclude showing certain data. I have now finalised and GROUPED the data I wanted in a way I wanted. Now when I try to set the filters to only show what I had originally exclused and delete the rows, it's also deleting my non-filtered stuff... So weird!

It's so strange... I don't understand it at all.

I set the filter to display what I WANT to delete ONLY. Then delete those rows. Then reset the filter to show what I did want, but the TOTAL at the bottom is different to what it was before deleting...

I have attached my workbook in the hope that someone can help me with this.

Notice the TOTAL with the filters is 3,138,536.

Thanks for any help!!

can you explain that please?

but surely the visible total (SUM) should only calculate visible cells, i.e. not calculate the filtered cells? i think it would be more sensible to delete the data that is not needed (the filtered data) - but i can't seem to do that without it affecting the total figure...

with the filter on i get all different figures! i dont get this at all!