In QR.xlsx, I have 5 sheets: Agrigate, Q1, Q2, Q3 and Q4.

In Agrigate, I would like to sum the total occurrences of the string TREPAC from across the entire workbook.

I have attempted =COUNTIFS('[QR.xlsx]Q1 13'!$A:$D, "TREPAC", '[QR.xlsx]Q2 13'!$A:$D, "TREPAC", '[QR.xlsx]Q3 13'!$A:$D, "TREPAC", '[QR.xlsx]Q4 13'!$A:$D, "TREPAC")
which produced a value of 0.

I also tried a similar thing that was =sum( =count(x), =count(x), ... ) but that was a total mess.

Can anyone check my syntax on the above line?

Anybody know of a better formula to use, or a better way to use the counifs formula?