So i've looked through the help section about this topic but couldn't find anything about averaging tabs. When i tried to use the help listed it didn't work. Can anyone help with the following formula trying to average 3 cells from 3 different tabs and ignoring the blanks. right now it sees the blank as a zero and comes back with a much lower average than it should be. Thanks in advance!

=AVERAGE(VLOOKUP($B6,AUG11!$A$2:$Z$1000,12,FALSE),VLOOKUP($B6,SEP11!$A$1:$Z$1000,12,FALSE),VLOOKUP($B6,OCT11!$A$1:$Z$1000,12,FALSE))