How do I combine a Vlook up function and average?

[JennyLH]

Hi All

Im currently using a spreadsheet which uses the vlookup function to pull specific data from 3 different worksheets if it meets the criteria and provide me with the total sum of this data.

=VLOOKUP($B4,January!$B$4:$X$44,8,TRUE)+(VLOOKUP($B4,February!$B$4:$X$44,8,TRUE)+(VLOOKUP($B4,March!$B$4:$X$44,8,TRUE)))


However I also want to be able to caculate the average of these 3 figures (if I divide the above formula by 3 it's not given me the average)

Does anyone have any idea on how I could combine average with the above formula or if there is another formula I could use?

 

[WinteE]

That means that the average you need is not the average of just this three months ?

 

[Chris Macro]

If you divide by three without wrapping your summed numbers in parenthesis you are actually performing x + y + (z/3). What you will want to do is (x+y+z)/3 or I assume you could wrap an AVERAGE() function around all the vlookups (example: =AVERAGE(VLOOKUP + VLOOKUP + VLOOKUP) )