COUNTIF Copying

[NEM510]

Hi there -

I have a spreadsheet with a worksheet for each month containing various bits of information

I am trying to set up a summary page that shows how often a term ('Smith', 'Jones', 'Johnson', etc) occurs in each month. I want to see how often a customer has contacted me each month and overall.

My summary page should have columns for each month and rows for each customer. I have used the following COUNTIF formula (example for the April column and the Smith row) =COUNTIF('April2018'!F3:F30,"Smith" and (May, Smith) =COUNTIF('May2018'!F3:F53,"Smith" and (April, Jones) =COUNTIF('April2018'!F3:F30,"Jones"

Is there a way to copy these without having to edit each cell manually?

thanks!

 

[WaterGypsy]

I'd do this using a formula like this in H11:

=COUNTIF(INDIRECT("'"&H$10&"'!F:F"),$G11)

Cell H10 will contain the name of the sheet (e.g April2018), and can be extended across the sheet into I, J, K etc
Cell G11 and down from there the client names

You can then copy the formula into each cell as required