I have a worksheet with a list of names like this

A
Staff
Joe
Suzie
Sally
Sam

And another worksheet that has a pivot table of data that I need to sum
across certain columns

A B C D E F G
Staff 4/1 4/2 4/6 4/7 4/8 4/9
Joe 4 2 9 1
Suzie 2 3 5 3
Sally 10 14 10 8 12
Sam 9 2 4 12 13 7


How can I give the results of the columns D through G where the name matches
the other sheet?

And also, I will then need the average of culumns D through G, excluding
zeros!

I can't it to work using the following formula

=SUMIFS('[Outcalls - April.xls]Rep By Day'!$E:$M,'[Outcalls - April.xls]Rep
By Day'!$A:$A,"="&A2)