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.