Guest User

Untitled

a guest
Jan 27th, 2014
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. =(IF(ISNUMBER(VLOOKUP(A3, Jan!$A$1:Jan!$AG$45, 33,FALSE)), VLOOKUP(A3, Jan!$A$1:Jan!$AG$45, 33,FALSE), 0)+IF(ISNUMBER(VLOOKUP(A3, Feb!$A$1:Feb!$AD$45, 30,FALSE)), VLOOKUP(A3, Feb!$A$1:Feb!$AD$45, 30,FALSE), 0)+IF(ISNUMBER(VLOOKUP(A3, Mar!$A$1:Mar!$AG$44, 33,FALSE)), VLOOKUP(A3, Mar!$A$1:Mar!$AG$44, 33,FALSE), 0)+IF(ISNUMBER(VLOOKUP(A3, Apr!$A$1:Apr!$AF$45, 32,FALSE)), VLOOKUP(A3, Apr!$A$1:Apr!$AF$45, 32,FALSE), 0)+IF(ISNUMBER(VLOOKUP(A3, May!$A$1:May!$AG$45, 33,FALSE)), VLOOKUP(A3, May!$A$1:May!$AG$45, 33,FALSE), 0)+IF(ISNUMBER(VLOOKUP(A3, June!$A$1:June!$AF$44, 32,FALSE)), VLOOKUP(A3, June!$A$1:June!$AF$44, 32,FALSE), 0)+IF(ISNUMBER(VLOOKUP(A3, July!$A$1:July!$AG$44, 33,FALSE)), VLOOKUP(A3, July!$A$1:July!$AG$44, 33,FALSE), 0)+IF(ISNUMBER(VLOOKUP(A3, Aug!$A$1:Aug!$AG$44, 33,FALSE)), VLOOKUP(A3, Aug!$A$1:Aug!$AG$44, 33,FALSE), 0)+IF(ISNUMBER(VLOOKUP(A3, Sep!$A$1:Sep!$AF$44, 32,FALSE)), VLOOKUP(A3, Sep!$A$1:Sep!$AF$44, 32,FALSE), 0)+IF(ISNUMBER(VLOOKUP(A3, Oct!$A$1:Oct!$AG$44, 33,FALSE)), VLOOKUP(A3, Oct!$A$1:Oct!$AG$44, 33,FALSE), 0)+IF(ISNUMBER(VLOOKUP(A3, Nov!$A$1:Nov!$AF$44, 32,FALSE)), VLOOKUP(A3, Nov!$A$1:Nov!$AF$44, 32,FALSE), 0)+IF(ISNUMBER(VLOOKUP(A3, Dec!$A$1:Dec!$AG$44, 33,FALSE)), VLOOKUP(A3, Dec!$A$1:Dec!$AG$44, 33,FALSE), 0))
Advertisement
Add Comment
Please, Sign In to add comment