Countif formulas change after doing a sort

Tech-Archive recommends: Speed Up your PC by fixing your registry

I'm experiencing a bit of problem recently in a few of my workbooks. 100
Formulas are in the H column counting entries in column D. The name of the
sites are in column G with the formulas in column H. The formulas are to
count the site names in top 100 listings in column d out of appx 3000
entries. The formula is =COUNTIF(D1:D100,G5) going all the way down to cell
G105. When I do an descending sort on those cells in columns G & H, the
formulas in some cells will change to any variable of d1: through d11: and
:d90 to :d110 or any other number for that matter.

After doing the sorts, I can fix the formulas by selecting the H Column,
then doing a Edit - Replace d?: to d1:, and then :d9? to :d100 & :d1?? to
:d100.

My question is why do these formulas change after doing a sort. It's a PITA
to fix those formulas each time I do a sort on the columns.

Any help or advice to fix this snafu would be appreciated.

Bob


.

Relevant Pages

  • Re: Countif formulas change after doing a sort
    ... Bob ... When I do an descending sort on those cells in columns G & H, ... > After doing the sorts, I can fix the formulas by selecting the H Column, ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Countif formulas change after doing a sort
    ... When I do an descending sort on those cells in columns G & H, ... After doing the sorts, I can fix the formulas by selecting the H Column, ... My question is why do these formulas change after doing a sort. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Sorting Linked Data Between Sheets
    ... If I could name cells so the names continued ... information as to how to sort the source sheet while the linked refernces on ... the destination sheet (in another workbook) refer to same cell data on the ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Sorting Blank Cells
    ... show where empty cells are, and what I see you having is one person's name ... sort the names ... Dim lastRelRow As Long ... Dim rOffset As Long ...
    (microsoft.public.excel.misc)
  • Re: Referencing Dancing Columns from another worksheet
    ... When i try to sort on the above column, it does not sort out the empty ... interpreted as cells. ... I have to manually key in the row reference I would like to be ... explained how to use Column headers in a formula. ...
    (microsoft.public.excel.worksheet.functions)