What do you want to do with this? Is is possibly a SUMPRODUCT formula?
Since I'm having some SUMPRODUCT difficulties today, I'll leave this to
someone else.

"datasorter" wrote:

can anyone tell me whats wrong with this formula and how to fix it?

=sumif(and('[Upsell Monthly Report.xls]COB'!$A:$A,'[Upsell Monthly
Report.xls]COB'!$C:$C),(A8,B8),('[Upsell Monthly Report.xls]COB'!$I:$I)