SumProduct / CountIf Array Error

[Hudson]

Can you look at Cell E15 of Tab 2 - why is this formula failing?

Thanks!

[Andy Pope]

You have #N/A's in column F on the Data Input sheet.

[canapone]

Hi,

all the arguments must have same size

=SUMPRODUCT(('Data Input'!$F$2:$F$2995=B15)/COUNTIF('Data Input'!$B$2:$B$2995;'Data Input'!$B$2:$B$2995&""))

Hope it helps

[Hudson]

Thanks - How can there be decimals in Cells E16 and E17 - how can a partial facility be surveyed?
The formula is pulling unique facility names?

[daddylonglegs]

Try this version

=SUMPRODUCT(('Data Input'!F$2:F$3000=B15)/COUNTIFS('Data Input'!F$2:F$3000,'Data Input'!F$2:F$3000&"",'Data Input'!B$2:B$3000,'Data Input'!B$2:B$3000&""))

[Hudson]

perfect!

Thanks