SUMIF VBA Does not contain text

JoeExcelHelp
5StarLounger
Posts: 1177
Joined: 22 Jul 2013, 18:29

SUMIF VBA Does not contain text

Post by JoeExcelHelp »

Hi Everyone,

Its been a while and I hope everyone is well


I have these 2 lines that support a SUMIF statement
Im checking if the condition in column 6 contains the text in RC1 but does not contain the word "Supervisor"
Cant get it to work.. Please help

Code: Select all

sFile & "C6,""*""&RC1&""*""," & _
sFile & "C6,""<>*Supervisor*""," & _

Code: Select all

"=SUM(SUMIFS(" & sFile & "C12," & _
                sFile & "C6,""*""&RC1&""*""," & _
                sFile & "C6,""<>*Supervisor*""," & _
                sFile & "C8,""=""&RC2," & _
                sFile & "C7,""=""&R1C4," & _
                sFile & "C13,""=""&Month(R12C)," & _
                sFile & "C14,""=""&Year(R12C)," & _
                sFile & "C1,"">""&R5C2," & _
                sFile & "C3,""<>""," & _
                sFile & "C4,""<>""," & _
                sFile & "C11,""Yes""," & _
                sFile & "C9,""Permanent""," & _
                sFile & "C5,{""Rehire"",""External"",""Internal Requisition""}))"

JoeExcelHelp
5StarLounger
Posts: 1177
Joined: 22 Jul 2013, 18:29

Re: SUMIF VBA Does not contain text

Post by JoeExcelHelp »

Disregard guys it worked