chanbrig wrote...
....
Both versions (short and long formula) gave me the mesage "the formula
you typed contains an error".

Here it is again...

Short version:
=(SUMPRODUCT(--('S:\June\[Metzger.xls]MONTHLY
REPORTS'!$C$15:$C$24=2)),+SUMPRODUCT(--('S:\June\[Opp.xls]MONTHLY
REPORTS'!$C$15:$C$24=2)),+SUMPRODUCT(--('S:\June\[Burke.xls]MONTHLY
REPORTS'!$C$15:$C$24=2)))*2

Oops! My fault. There should be no commas, so this should be

=(SUMPRODUCT(--('S:\June\[Metzger.xls]MONTHLY REPORTS'!$C$15:$C$24=2))
+SUMPRODUCT(--('S:\June\[Opp.xls]MONTHLY REPORTS'!$C$15:$C$24=2))
+SUMPRODUCT(--('S:\June\[Burke.xls]MONTHLY REPORTS'!$C$15:$C$24=2)))*2

Long version:
....

From what I can see, the long version should work. Where does Excel say
there's an error?