jason061872
New Member
- Joined
- Apr 1, 2019
- Messages
- 13
=IFERROR(SUMPRODUCT(SUMIFS(INDIRECT("'"&$A$4:$A$22&"'!B132:K132"),INDIRECT("'"&$A$4:$A$22&"'!B4:K4"),B4,INDIRECT("'"&$A$4:$A$22&"'!B5:K5"),$Q$4))/SUMPRODUCT(COUNTIFS(INDIRECT("'"&$A$4:$A$22&"'!B4:K4"),B4,INDIRECT("'"&$A$4:$A$22&"'!B5:K5"),$Q$4)),IF(D4=1,SUMPRODUCT(SUMIFS(INDIRECT("'"&$A$4:$A$22&"'!B132:K132"),INDIRECT("'"&$A$4:$A$22&"'!B4:K4"),B4,INDIRECT("'"&$A$4:$A$22&"'!B5:K5"),$Q$4))/1,""))
This formula is designed to average a series of scores overmultiple worksheets in a single workbook based on criteria that may change overtime. The cells B132:K132 do notautomatically update if I add or remove a row that comes before line 132. Can anyone tell me why or better yet how tofix this issue?
This formula is designed to average a series of scores overmultiple worksheets in a single workbook based on criteria that may change overtime. The cells B132:K132 do notautomatically update if I add or remove a row that comes before line 132. Can anyone tell me why or better yet how tofix this issue?