Create a reference that displays linking between cell C3 of Sheet1 and cell C3 in Sheet 4 of Sheet5 to get average. Share with your friends Share 1 Nitin Choudhary answered this 2. written with pencil above 5 View Full Answer Neha answered this =sum(sheet1!C3,sheet4!C3) -1