It's *still* not clear (to me) exactly what criteria refers to what range.

The way the OP formula was constructed, anything is (was) possible.<g
--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

"Peo Sjoblom" wrote in message
...
True but my formula was wrong since I didn't observe that the OP used the A,
the C and the I range, so it would be a regular sumproduct not the OR
version I cooked up so

=SUMPRODUCT(--('[Upsell Monthly
Report.xls]COB'!$A$19:$A$1075=A8),--('[Upsell
Monthly Report.xls]COB'!$C$19:$C$1075=C8),'[Upsell Monthly
Report.xls]COB'!$I$19:$I$1075)

might work


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com




"Ragdyer" wrote in message
...
Your ranges are *not equal*!

They *must all* be exactly the same size.

A19:A944
C19:C891
I19:I1075

Pick whatever range best suits your data, and equalize them ... THEN ...
try again!

--
HTH,

RD

--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit !
--------------------------------------------------------------------------
-
"datasorter" wrote in message
...
I tried this and I got #N/A

=SUMPRODUCT(--(('[Upsell Monthly
Report.xls]COB'!$A$19:$A$944=A8)+('[Upsell
Monthly Report.xls]COB'!$C$19:$C$891=C8)0),'[Upsell Monthly
Report.xls]COB'!$I$19:$I$1075)