Countif Cell equals Active Worsheet

[tcnt9176]

Hello. I need to enter a countif formula if a cell equals the name of the active worksheet and also cell A1. My worksheets are not always the same and I also want to be able to copy this formula to multiple worksheets so if the formula states active worksheet then is should work properly when I past it to multiple tabs (at least in my head).
Thanks. Chris

 

[tcnt9176]

Just to Add to my last post, the following worked. I now need to do this same thing but only where the cell in column C of the Placement Detail equals the name of the active worksheet. Here is the one that works and then the script that I know works for limiting it to claims where column C equals the name of the active worksheet. The problem I am having is combining them. Thanks.

ActiveCell.FormulaR1C1 = _
"=SUMPRODUCT(--('Placement Detail'!C[10]=RC[-1]),--('Placement Detail'!C=9999)) + SUMPRODUCT(--('Placement Detail'!C[10]=RC[-1]),--('Placement Detail'!C=9000))"



--('Placement Detail'!R[-2]C[2]:R[9997]C[2]=RIGHT(CELL(""filename""),LEN(CELL(""filename""))-SEARCH(""]"",CELL(""filename""),1))))"