Okay, I have this spreadsheet where I must sum the totals of a column of data only if it matches two seperate criteria. In it I must seperate the rework created by each line per crew.
This is the formula I am trying (and have tried multiple variations of the same) where A is the crew, B is the line, and C is the rework:
=IF($B$2:$B$17=1, SUMIF($A$2:$A$17,"=1",$C$2:$C$17), 0)
Seems logical to me, but it delivers incorrect data. Can anyone help me?
Here is the attached file:
Bookmarks