I have a workbook with several data pages, one for each client and hundreds of lines of data for each. I created a summary page to automatically pull the data I need into a single sheet. I am using a lot of Countif and Countifs as I need to know the number of times Yes or No appears in a column...