formulas in cells change when using filter function
 

column L uses a 'countif' formula to determine the number of times a specific
# appears in column F. after formulas were entered, i filtered the data, and
the range for many of those formulas changed. how do i fix this?

formulas in cells change when using filter function
 

How do the formulas change? Can you show an example? I'm a very poor mind
reader

Tyro

"hoosier data" <hoosier wrote in message
...
column L uses a 'countif' formula to determine the number of times a
specific
# appears in column F. after formulas were entered, i filtered the data,
and
the range for many of those formulas changed. how do i fix this?

formulas in cells change when using filter function
 

sorry; in col L, the countif statement reads: countif(f2:f189,"some specific
#") - where i'm looking for the number of times a specific # appears in col F.
The formulas in this column never changed until i filtered data, and now
when I go back, there are several iterations of it; countif(f6:f189,"spec #")
countif(f18:f189,"spec #")
countif(f23:f189,"spec #"), etc
does that help?

"Tyro" wrote:

How do the formulas change? Can you show an example? I'm a very poor mind
reader

Tyro

"hoosier data" <hoosier wrote in message
...
column L uses a 'countif' formula to determine the number of times a
specific
# appears in column F. after formulas were entered, i filtered the data,
and
the range for many of those formulas changed. how do i fix this?