Boolean (blue flag) troubles

IF is structured like this:

=IF(if-expression,if-true,if-false)

You've got only two of the required three. Add the third (i.e. you need both an if-true and if-false) and all will be well.

However, I don't think you should need a long formula like that. I think you can consider using SUMIF or SUMIFS.

SUMIF – Apple Support (UK)

SUMIFS – Apple Support (UK)

SG

Not enough information to be sure but I think it is because you did not include any "else" (if false) results in your IF statements.

=IF(condition, if_true, if_false)

If one of your conditions is not met, the IF statement returns FALSE. FALSE is a boolean, not a number. Numbers will convert it into a zero if you are using it in a math formula but will warn you about it. This may be what you want:

=IF(B11=Abbreviation Level II Tech, ST Level II Tech, 0)

There may be an easier way to do what you are trying to do. Often when a formula includes a lot of similar sub-formulas (like all your IFs added together) there is a simpler way to do it.

Please go into Numbers Preferences and turn off "use header names as labels". It makes it so much easier for us to help when formulas use the normal B11 type references instead of those long names.

Formula in C10 =XLOOKUP(B10,Labor Rates::$B,Labor Rates::C,"Not Found",0)

Fill down and across to complete the table.