Sumproduct - multiple Sum ifs
 

=((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.

Sumproduct - multiple Sum ifs
 

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" wrote:

=((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.

Sumproduct - multiple Sum ifs
 

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

Sumproduct - multiple Sum ifs
 

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


"Louja" wrote:

=((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.

Sumproduct - multiple Sum ifs
 

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


"Louja" wrote:

=((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.