SUMPRODUCT Problem

[dhx10000]

Hi,

I've been using the Sumproduct function just fine but now, I keep getting an #N/A value. I just can't see what I'm doing wrong. Below is the formula:

=SUMPRODUCT((IF(FREQUENCY('BarcelonaInternalActions-logView.xls'!Issue_ID,'BarcelonaInternalActions-logView.xls'!Issue_ID)>0,1))*(CAK1QR0L!S2:S5305=43))

I have two ranges, IssueID, which contains duplicate ID numbers, which is why I am using the FREQUENCY function to only the unique numbers. the other column I am referencing is a list of numbers from 1-52.

I am just trying to get a count of all unique IssueID's, or records that equal 43.

Thank you,

 

[tactps]

It is likely that the source data contains "N/A" somewhere. Check the named ranges for n/a errors.

 

[Ronald Moore]

The array FREQUENCY(LIST,LIST) contains 1 more element than the range LIST. Try changing S5305 to S5306.