=sum(countifs('filtered'!$B:$B,$D$2,'filtered'!$S:$S,A3),Countifs('filtered'!$T:$T,A3,'filtered'!$AC:$AC,$D$2))
I would like to write a macro that will run this function in the background (so I only see the result when I click in the cells) and in the function where it says "A3" I would like it to reference column 1.
I would like to write a macro that will run this function in the background (so I only see the result when I click in the cells) and in the function where it says "A3" I would like it to reference column 1.