Counting non-empty merged cells on another closed document with SUMPRODUCT

[baxius]

Hello.
I am trying to count non-empty cells on another closed document with SUMPRODUCT.
I am using this formula:

Please Login or Register  to view this content.

Everything seems fine until the array encounters merged cells and returns #REF! from those cells, as seen in formula evaluation window:
gkTFa.png
How to solve this problem. Easiest way is just to unmerge those cells or there are other formulas? Maybe there is a way to change those #REF! to 1's? Or maybe a VBA macro would be more suitable?

Thank you for your insights and help.

P.S. question also posted here 23 hours ago. https://stackoverflow.com/questions/...ith-sumproduct

[Pepe Le Mokko]

Administrative note

Welcome to the forum

in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

Please take a moment to read it and attach a sheet accordingly.

Thanks you for helping us help you

[baxius]

The formula started to work for some reason.
Marking as solved.