I am trying to condense a formula which count across multiple sheets. Why would formula 1 work and formula 2 not work?
Formula 1
=COUNTIFS('A1'!$A$10:$A$5555,A55,'A1'!$W$10:$W$5555,"H")+COUNTIFS('A2'!$A$10:$A$5555,A55,'A2'!$W$10:$W$5555,"H")+COUNTIFS('A3'!$A$10:$A$5555,A55,'A3'!$W$10:$W$5555,"H")+COUNTIFS('A4'!$A$10:$A$5555,A55,'A4'!$W$10:$W$5555,"H")+COUNTIFS('A5'!$A$10:$A$5555,A55,'A5'!$W$10:$W$5555,"H")+COUNTIFS('A6'!$A$10:$A$5555,A55,'A6'!$W$10:$W$5555,"H")+COUNTIFS('A7'!$A$10:$A$5555,A55,'A7'!$W$10:$W$5555,"H")
Formula 2
=COUNTIFS('A1:A7'!$A$10:$A$5555,A55,'A1:A7'!$W$10:$W$5555,"H")
Formula 1
=COUNTIFS('A1'!$A$10:$A$5555,A55,'A1'!$W$10:$W$5555,"H")+COUNTIFS('A2'!$A$10:$A$5555,A55,'A2'!$W$10:$W$5555,"H")+COUNTIFS('A3'!$A$10:$A$5555,A55,'A3'!$W$10:$W$5555,"H")+COUNTIFS('A4'!$A$10:$A$5555,A55,'A4'!$W$10:$W$5555,"H")+COUNTIFS('A5'!$A$10:$A$5555,A55,'A5'!$W$10:$W$5555,"H")+COUNTIFS('A6'!$A$10:$A$5555,A55,'A6'!$W$10:$W$5555,"H")+COUNTIFS('A7'!$A$10:$A$5555,A55,'A7'!$W$10:$W$5555,"H")
Formula 2
=COUNTIFS('A1:A7'!$A$10:$A$5555,A55,'A1:A7'!$W$10:$W$5555,"H")