Sumproduct - multiple Sum ifs

[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.

 

[Mike H]

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

 

[Louja]

Thanks - I had somehow figured that myself just after posting it that
I had column headings and that is the problem.

 

[bosco_yip]

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

 

[bosco_yip]

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