I am trying to count how many times "AV" appears in a specific range in a seperate worksheet and have that counted value returned into my "roll-up sheet".
However, because the row #'s can vary due to me adding or deleting rows, my range is never the same twice. I would like to know if there is anyway to count the cells if it sees "AV" and know that I only want to count the range that has a certain number (4305) somewhere within the row?
Please help!
However, because the row #'s can vary due to me adding or deleting rows, my range is never the same twice. I would like to know if there is anyway to count the cells if it sees "AV" and know that I only want to count the range that has a certain number (4305) somewhere within the row?
Please help!