formulas in cells change when using filter function

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?
 
H

hoosier data

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 1
Excel Dragging countif formula with changing criteria 3
Excel Need Countifs Formula Help 0
CountIf formula problem when referencing a column. 4
Conditional formatting in Excel 2010 2
Average value only for the filtered area.. 4
subtotal filter with growing range 2
Searching alfanumaric cell contents and returning with a numaric v 21

Top