I will try to be as descriptive as possible, because I really need help. I have a column of information (B) that says either "Rat7" or "Rat8". One column to the right (C) is the text "Immobile", "Swim" or "Climb". I have written the macro to automatically sort B to separate the data into "Rat7" followed by Rat8". There are roughly 60 data points for each of "Rat7" and "Rat8", but not always. So here it is: I need a way to count the number of times "Rat7" or "Rat8" appears so I can then use the number to define the range to properly select the data in C so it can be used in another equation. I know how to use "COUNTIF", but I don't know how to use only the value to determine the range for inclusion. Here is an example: cells B1:B59 all have "Rat7", therefore there are 59 instances of "Rat7" so I want my equation to read: =COUNTIF(C1:C59,"Immobile") but if there are only 56 instances of "Rat7" (cells B1:B56) then I need it to read: =COUNTIF(C1:C56,"Immobile"). So How do I reference a value as the end parameter for a range. I know there is a genius out there who will understand this, and I have been working for far too long with out being able to get past this one stupid point. Thank you.