Averageif across tabs

[CoTsMark]

I am trying to do a conditional function across multiple tabs and multiple cells. Is it possible?

=AVERAGE('Sheet 1:Sheet10'!a15:a2000) works fine but when I add in the conditional if I receive a value error.


=AVERAGEIF('Sheet 1:Sheet 10'!C115:C2000,B2,'Sheet 1:Sheet10'!A15:A2000)

=AVERAGEIFS('Sheet 1:Sheet 10'!A15:A2000,'Sheet 1:Sheet 10'!C15:C2000,B2)

 

[Haseeb Avarakkan]

Hello, Try

Enter the all sheet names in the cells, let's say D1:D10, then

=SUMPRODUCT(SUMIF(INDIRECT("'"&$D$1:$D$10&"'!A:A"),B2,INDIRECT("'"&$D$1:$D$10&"'!C:C")))/SUMPRODUCT(COUNTIF(INDIRECT("'"&$D$1:$D$10&"'!A:A"),B2))