I have a workbook with 31 sheets (for the days of the month). I need to
create a summary count of how many times a certain "text" appears in cells
C65:C75 on the sheets of that workbook. The sheets are just named with the
numbers 1-31. I know that Countif does not work across multiple sheets and I
have tried arrays and nothing works. Please help :(