I am trying to get an If statement based on the data sample
If F:F from PDC Tab = "Labor" then sumif P:P from PDC Tab matching A:A from PDC Tab with B:B for Summary Tab
I will repeat the formula for items in F:F that read "NON-Labor"
IF(DATA_PDC!F:F= "LABOR",SUMIFS(DATA_PDC!P:P,DATA_PDC!A:A,B4))
this is what I have and I get a Spill error
Last edited by a moderator: