G
Guest
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.
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.