please send example file
still unclear of what you are trying to do you want to get an average of what exactyl?
ok, still not following, which particular columns do you want to sum on which sheet, what criteria do you want to use, and where is that criteria comming from, and which cell on which sheet should the result go in.
sorry it is unclear to me as to exactly what you want to accomplish, so for that reason I will open your question to other experts
I will try to help you in it.
I got your Question. I will start working on it.
Can you please give me complete sheet as you have use column L in your formula but in the sheet you gave me you have given data in that column
try using &A2 in place of "Giancarlo DiPierro" . It should work
Did you try above suggestion ? Did this work for you ?