S
Six Sigma Blackbelt
My vlookup formula goes like this
=VLOOKUP($A2,December!$C$3:$H$68,3,FALSE)+VLOOKUP($A2,January!$C$3:$H$65,3,FALSE)+VLOOKUP($A2,February!$C$3:$H$74,3,FALSE)+VLOOKUP($A2,March!$C$3:$H$85,3,FALSE)+VLOOKUP($A2,April!$C$3:$H$85,3,FALSE)
The formula finds a name an adds the numbers associated with that name in
the cells together, but some of the months like April do not have the names
of the people so the vlookup returns #N/A instead of the sum, because that
name could not be found in the specified tab labeled March or April. What
kind of IF Statement can i use to continue adding the cells even if that
persons name dosen't show up in that tab.
=VLOOKUP($A2,December!$C$3:$H$68,3,FALSE)+VLOOKUP($A2,January!$C$3:$H$65,3,FALSE)+VLOOKUP($A2,February!$C$3:$H$74,3,FALSE)+VLOOKUP($A2,March!$C$3:$H$85,3,FALSE)+VLOOKUP($A2,April!$C$3:$H$85,3,FALSE)
The formula finds a name an adds the numbers associated with that name in
the cells together, but some of the months like April do not have the names
of the people so the vlookup returns #N/A instead of the sum, because that
name could not be found in the specified tab labeled March or April. What
kind of IF Statement can i use to continue adding the cells even if that
persons name dosen't show up in that tab.