formulas in cells change when using filter function

  • Thread starter Thread starter hoosier data
  • Start date Start date
H

hoosier data

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