Sumproduct #Value

[dannyh]

Hi All

Have done a lot of searching and cant find an answer as to why my formula is returning #Value

=SUMPRODUCT(--('1.RevenueRec'!$B$2:$C$10000=B$1),--('1.RevenueRec'!$A$2:$A$10000=$A3),'1.RevenueRec'!$I$2:$I$10000)

I have checked and double checked column I in my data sheet, they are all values.

Can anyone think of another reason as to why I might be getting an error returned ?

Thanks Daniel

 

[Joe4]

Your ranges must all be the same size. The first one spans two columns, while other two span one.

[COLOR=#333333]'1.RevenueRec'![/COLOR][COLOR=#ff0000][B]$B$2:$C$[/B][/COLOR][COLOR=#333333]10000=B$1[/COLOR]

 

[dannyh]

Your ranges must all be the same size. The first one spans two columns, while other two span one.

[COLOR=#333333]'1.RevenueRec'![/COLOR][COLOR=#ff0000][B]$B$2:$C$[/B][/COLOR][COLOR=#333333]10000=B$1[/COLOR]

Thanks Joe, I thought I had checked my ranges must of missed that one !