I’m trying to use an if statement in excel to collect the required information from 2 separate tabs. The problem l’m facing is that on the 3rd and last if statements excel only calculates the results from the 3rd one and ignores the rest.Any help would be truly appreciated.
Formula:
=IF($E221="1 BWR",SUMIFS('Hours (1)'!$M:$M,'Hour(1)'!$N:$N,'Pack'!$D221,
'Hours (1)'!$A:$A,'Pack'!$A221,'Hours (1)'!$B:$B,"TEMPS"),
IF($E221="2 BWR",SUMIFS('Hours (2)'!$G:$G,'Hours (2)'!$H:$H,'Pack'!$D221,
'Hours (2)'!$A:$A,'Pack'!$A221,'Hours (2)'!$C:$C,"TEMPS"),
IF($E221="3 BWR",SUMIFS('Hours (3)'!$F:$F,'Hours (3)'!$G:$G,'Pack'!$D221,
'Hours (3)'!$A:$A,'Pack'!$A221,'Hours (3)'!$C:$C,"TEMPS"),
IF($E221="3 BWR",SUMIFS('Hours (3)'!$H:$H,'Hours (3)'!$I:$I,'Pack'!$D221,
'Hours (3)'!$A:$A,'Pack'!$A221,'Hours (3)'!$C:$C,"TEMPS"),""))))
