Hello.
I am trying to count non-empty cells on another closed document with SUMPRODUCT.
I am using this formula:
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
Bookmarks