Hello Oeldere,
Here is the formula used:
=AVERAGE(Jan_Data!D2,Feb_Data!D2,Mar_Data!D2,Apr_Data!D2,May_Data!D2,Jun_Data!D2,Jul_Data!D2,Aug_Data!D2,Sep_Data!D2,Oct_Data!D2,Nov_Data!D2,Dec_Data!D2)
I have used the IFERROR and still get an error: "You've entered to many arguments for this function"
=IFERROR(AVERAGE(Jan_Data!D2,Feb_Data!D2,Mar_Data!D2,Apr_Data!D2,May_Data!D2,Jun_Data!D2,Jul_Data!D2,Aug_Data!D2,Sep_Data!D2,Oct_Data!D2,Nov_Data!D2,Dec_Data!D2)
I have used the AVERAGEIF and still get an error - "You've entered to many arguments for this function"
=AVERAGEIF(Jan_Data!D2,Feb_Data!D2,Mar_Data!D2,Apr_Data!D2,May_Data!D2,Jun_Data!D2,Jul_Data!D2,Aug_Data!D2,Sep_Data!D2,Oct_Data!D2,Nov_Data!D2,Dec_Data!D2)
I have used the AVERAGEIFS and still get an error - "You've entered to few arguments for this function"
=AVERAGEIFS(Jan_Data!D2,Feb_Data!D2,Mar_Data!D2,Apr_Data!D2,May_Data!D2,Jun_Data!D2,Jul_Data!D2,Aug_Data!D2,Sep_Data!D2,Oct_Data!D2,Nov_Data!D2,Dec_Data!D2)
Regards,
John
Bookmarks