Sumproduct - multiple Sum ifs

  • Thread starter Thread starter Louja
  • Start date Start date
L

Louja

=((SUMPRODUCT(--('Group Rate'!$A$3:$A$255=M2),--('Group Rate'!$B$3:$B
$255=F2),--('Group Rate'!$E$3:$E$255))))

I get a Value error when trying to use the above formula but am unsure
why as it does work for similar instances. Any help is appreciated.
 
Hi,

The formula is fine so a value error would be returned if there are non
numeric values in column E, check you have no text in that range.

Mike
 
Thanks - I had somehow figured that myself just after posting it that
I had column headings and that is the problem.
 
Try this instead :

=((SUMPRODUCT(--ISNUMBER(FIND(M2,'Group
Rate'!$A$3:$A$255)),--ISNUMBER(FIND(F2,'Group Rate'!$B$3:$B$255)),--('Group
Rate'!$E$3:$E$255))))

Regards
Bosco
 
Try this instead :

=((SUMPRODUCT(--ISNUMBER(FIND(M2,'Group
Rate'!$A$3:$A$255)),--ISNUMBER(FIND(F2,'Group Rate'!$B$3:$B$255)),--('Group
Rate'!$E$3:$E$255))))

Regards
Bosco
 
Back
Top