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""}))"