Thanks Roger, but how can the formula grab the right info, with the vlookup,
its searching by name then going to the assigned row to find the number,
adding that number to the next number in the next sheet by the same name,
then I want it to skip the sheet if the name dosen't appear on the sheet and
move to the next to continue the process for the selected sheets

"Roger Govier" wrote:

Hi

You could do it a different way.
On your Summary sheet, list your Sheet names - I used F1:F4 - then the
formula
=SUMPRODUCT((SUMIF(INDIRECT($F$1:$F$4&"!C3:C85"),A 2,INDIRECT($F$1:$F$4&"!E3:E85"))))

--
Regards
Roger Govier

"Six Sigma Blackbelt" wrote in
message ...
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,Februa ry!$C$3:$H$74,3,FALSE)+VLOOKUP($A2,March!$C$3:$H$8 5,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.