[Solved] Help me on this Leave Tracker Name 6 to 14 formula dont work
- Thread starter jerubin
- Start date
Hello Jerubin,
The formula is showing only 5 names data because you didn't update the cell reference to include the rest of the names.
Updated Formula:
=IFERROR(INDEX(Jan!AJ$9:AJ$23,MATCH($B11,Jan!$C$9:$C$23,0)),0)+IFERROR(INDEX(Feb!AJ$9:AJ$23,MATCH($B11,Feb!$C$9:$C$23,0)),0)+IFERROR(INDEX(Mar!AJ$9:AJ$23,MATCH($B11,Mar!$C$9:$C$23,0)),0)+IFERROR(INDEX(Apr!AJ$9:AJ$23,MATCH($B11,Apr!$C$9:$C$23,0)),0)+IFERROR(INDEX(May!AJ$9:AJ$23,MATCH($B11,May!$C$9:$C$23,0)),0)+IFERROR(INDEX(Jun!AJ$9:AJ$23,MATCH($B11,Jun!$C$9:$C$23,0)),0)+IFERROR(INDEX(Jul!AJ$9:AJ$23,MATCH($B11,Jul!$C$9:$C$23,0)),0)+IFERROR(INDEX(Aug!AJ$9:AJ$23,MATCH($B11,Aug!$C$9:$C$23,0)),0)+IFERROR(INDEX(Sep!AJ$9:AJ$23,MATCH($B11,Sep!$C$9:$C$23,0)),0)+IFERROR(INDEX(Oct!AJ$9:AJ$23,MATCH($B11,Oct!$C$9:$C$23,0)),0)+IFERROR(INDEX(Nov!AJ$9:AJ$23,MATCH($B11,Nov!$C$9:$C$23,0)),0)+IFERROR(INDEX(Dec!AJ$9:AJ$23,MATCH($B11,Dec!$C$9:$C$23,0)),0)
The formula is showing only 5 names data because you didn't update the cell reference to include the rest of the names.
Updated Formula:
=IFERROR(INDEX(Jan!AJ$9:AJ$23,MATCH($B11,Jan!$C$9:$C$23,0)),0)+IFERROR(INDEX(Feb!AJ$9:AJ$23,MATCH($B11,Feb!$C$9:$C$23,0)),0)+IFERROR(INDEX(Mar!AJ$9:AJ$23,MATCH($B11,Mar!$C$9:$C$23,0)),0)+IFERROR(INDEX(Apr!AJ$9:AJ$23,MATCH($B11,Apr!$C$9:$C$23,0)),0)+IFERROR(INDEX(May!AJ$9:AJ$23,MATCH($B11,May!$C$9:$C$23,0)),0)+IFERROR(INDEX(Jun!AJ$9:AJ$23,MATCH($B11,Jun!$C$9:$C$23,0)),0)+IFERROR(INDEX(Jul!AJ$9:AJ$23,MATCH($B11,Jul!$C$9:$C$23,0)),0)+IFERROR(INDEX(Aug!AJ$9:AJ$23,MATCH($B11,Aug!$C$9:$C$23,0)),0)+IFERROR(INDEX(Sep!AJ$9:AJ$23,MATCH($B11,Sep!$C$9:$C$23,0)),0)+IFERROR(INDEX(Oct!AJ$9:AJ$23,MATCH($B11,Oct!$C$9:$C$23,0)),0)+IFERROR(INDEX(Nov!AJ$9:AJ$23,MATCH($B11,Nov!$C$9:$C$23,0)),0)+IFERROR(INDEX(Dec!AJ$9:AJ$23,MATCH($B11,Dec!$C$9:$C$23,0)),0)