I am in need of help, and hoping there is an easy fix for what i want to do.
In my workbook i have sheet "Activities"
Column A is the provider
Column C is the type of activity
Column E is the quarter the activity took place in.
I also have a sheet for source data. The data entered in the Activities sheet is validated by the data on the Source sheet.
So on the source sheet, i have a list of providers and a list of activities.
I have another sheet for quarter 1. In this sheet i have the function: =COUNTIFS('1920 Teaching activity details'!A:A, 'source data'!A2, '1920 Teaching activity details'!C:C, 'source data'!C9,'1920 Teaching activity details'!E:E, "Q1"). Basically, i want to know how many times provider 2 did activity 9 in quarter 1 of 2019. The function above works perfectly for that. However, i have to have this formula copied to dozens of providers. I tried copying and pasting. When i paste, the source data A2 pastes sequentially down the line which works fine, because the next line would be for provider in source A3, the next one for the provider in source 4, etc. The problem i have is the formula is also going sequential for the activity. So it says C10 in the next line, and then C11. I want to keep all the criteria the same with the exception of the provider. Is there an easy way to accomplish this so that i dont have to type this forumla thousands of times?
Bookmarks