If statement assistance

[dsami0122]

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

 

[Jeffrey Mahoney]

You don't nee the IF part of the function. SUMIFS should take care of what you need. What is in Cell B4? One of the Project ID's? You could write it like this:
=SUMIFS(DATA_PDC!P:P,DATA_PDC!A:A,B4,DATA_PDC!F:F,"Labor")

Or use a cell with Labor in it just like you did with the Project ID

 

[dsami0122]

Thank you