I am trying to count the number of times a part number appears in a column of
filtered data. The part number is repeated because I need to track serial
numbers with it. I tried using the Countif function but it takes into
accound values that are filtered out. I sorted my data by part number and
used the subtotal function with CountA. This gives me an accurate total but
I have to constantly change the range when I add more parts to the
spreadsheet.

Should I be using the Subtotal function or is there another way to total my
values without having to constantly make modifications? Thank you for any
help provided.