Bloubul,

I did say that "

**Note that it also counts the zero appearance of an address but its visibility is suppressed using conditional formatting in my version of Excel.**" On my count numbers sheet, Range B2:L11 looks exactly like yours with empty cells where there are zero counts.

I used conditional formatting to hide them. You have not told me what version of Excel you are using. Perhaps there is a compatibility issue with your undisclosed version, if you are not seeing what I'm seeing.

Without using conditional formatting the formulas get fiendishly complex as I have to add a lengthy IF statement around an already complex formula.

Anyway I have done that -changed the formulas to check for zero counts and not display them in the range B2:L11.

It would also have helped if you'd confirmed my assumptions about

**what to count**, in other words ignore everything on the cell numbers sheet OUTSIDE the range B3:L8 and N3:OZ12?

Only if that assumption is correct are the counts correct and there is no need to have any formulas on sheet "number count" below row 12. Confusingly, you have borders around cells below row 12 on sheet "number count" as if you are expecting some counts to appear there! This can never happen if the count range is the grey areas as I assumed.

**https://www.mediafire.com/file/y77wdy2qylueq0v/Cell_Adress_counter2.xlsx/file**

Is there a formula to count how many times, let's say $B$11 did appear in the Address counts.

BlouBul

I do not understand this question. It is ALREADY counting $B$11 and all the others in the GREY ranges you secified. Did you mean EVERYWHERE on the entire page ?

Please be more specific and more forthcoming with information if you want help.

Frank