Below is a formula I'm trying to pass into a cell via Access vba that's generating a Run-time error 1004, Application-defined or object-defined error.

"=SUMPRODUCT(SUBTOTAL(9,OFFSET(IBMT_Raw_Data!$C$2:IBMT_Raw_Data!$C$20000,ROW(IBMT_Raw_Data!$C$2:IBMT_Raw_Data!$C$20000)-ROW(IBMT_Raw_Data!$C$2),0,1)),--(IBMT_Raw_Data!$A$2:IBMT_Raw_Data!$A$20000=A" & lngColumn + 1 & "),--(IBMT_Raw_Data!$D$2:IBMT_Raw_Data!$D$20000=AR7)),--(IBMT_Raw_Data!$E$2:IBMT_Raw_Data!$E$20000<>AR1))"

I added the very last part recently and it was working before.

,--(IBMT_Raw_Data!$E$2:IBMT_Raw_Data!$E$20000<>AR1))

This part and the part right before it are looking at cells on the sheet. In these 2 parts, I'm trying to say "find all records with this value in one column but exclude records with this value in another column".

Any ideas as to why this isn't working?

Thanks!
Clint