Harlan!

I think I love you! ;)

THAT WORKED! I am using the short version. When I removed the commas,
it began calculating!


Just for my understanding. What does the *2 mean at the end of the
formula?

THANK YOU THANK YOU THANK YOU!

Harlan Grove Wrote:
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?


--
chanbrig
------------------------------------------------------------------------
chanbrig's Profile: http://www.excelforum.com/member.php...o&userid=36071
View this thread: http://www.excelforum.com/showthread...hreadid=558587