Count number of times a cell reference appears within formulae in a range

[kcmuppet]

Hi Guys,

In each of cells G85:96 I have a simple CountA formula like these:

in G85 =COUNTA(B21,B43,B44,B45)
in G85 =COUNTA(B21,B32,B44,B51)

...in which I have manually selected those cells in column B.

What I'd like to do in say H21 is have a count of the times that cell B21 appears in formulae in the range G85:96.

I've been reading about search and find, but not getting very far. Guidance much appreciated!

 

[kcmuppet]

Solution on Chandoo's forum: https://chandoo.org/forum/threads/c...-within-formulae-in-a-range.42972/post-256266