Do you have any #n/a's in that range that you're trying to count?

(But then you'd get the same #n/a if the workbook is open or closed.)

Egon wrote:

I have calculations set to Automatic, what I get when the workbook
isn't open is #N/A on the last formula.

--

Dave Peterson