So I have this function that is working wonderfully
=SUMPRODUCT(COUNTIF(INDIRECT("'04"&TEXT(ROW(INDIRECT("1:30")),"00")&" Detail'!C:C"),2118))
But now I need to change the worksheets so that the "Detail" worksheets are named "Raw Data"

And

Where I was looking for 2118 in column C I now need to find 2118 in a string of data in Column A that looks like this (always in the 3rd position)

20050401;18463213;2118;X;X;X;0


How should I modify my function?

Thanks,
Greg