Your code clued me in to what i'd done wrong.I had my countif functions on the same row i was hiding,doh.Easy done i suppose