Originally Posted by StarHunter What I am trying to achieve is replace the CountIF line in this code with a Sumproduct function: Why, what is wrong with COUNTIF?
____________________________________________ Nihil simul inventum est et perfectum Abusus non tollit usum Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen! James Thurber
Forum Rules