Hi. In a workbook, I am trying to write a function in a cell which returns the size of the overlap between two specified ranges. I think the range intersection operator is a space, so I want to write something like: = Count($A$1:$E$5 B2:F6), and I expect to get the answer 16 (i.e. the number of cells common to both ranges.
This does not work.
Can anybody suggest what I need to do please?
Thanks.
This does not work.
Can anybody suggest what I need to do please?
Thanks.