onsdag den 20. februar 2019 kl. 14.08.16 UTC+1 skrev Claus Busch:
Hi Jan,

Am Wed, 20 Feb 2019 04:57:16 -0800 (PST) schrieb Daddy Sage:

In one cell I have the following formula: =COUNTA(B2:B1000). Copying down I like ti to change the column to

=COUNTA(C2:C1000)
=COUNTA(D2:D1000) and so on.

for column B try:
=COUNTA(OFFSET($B$1,,ROW(A1)-1,1000))
ans copy down.


Regards
Claus B.
--
Windows10
Office 2016

In columns b I have 6 values, in column C I have 10 values and in column C I have 8 values.

If I enter the fomular in E2 and copy down it just counts everything ad zeroes.