Hi, I need this formula converted into an Excel 2003 friendly formula: SUMIFS(Income!$P:$P,Income!$E:$E,$Q$6:$Q$70,Income!$C:$C,$R$5)

I assume SUMPRODUCT will do it? Something like: SUMPRODUCT((Income!$P:$P)*(Income!$E:$E=$Q$6:$Q$70)*(Income!$C:$C=$R$5))

But that SUMPRODUCT gives me a #VALUE!.

Income!$P:$P = column of amounts
Income!$E:$E = column of peoples names
$Q$6:$Q$70 = column of peoples names
Income!$C:$C = column of status (Invoiced or Paid)
$R$5 = Paid

I would appreciate a little help please.

Thanks

Peter