If I understand what you are trying to do, try this:
=COUNTA($A.A:A,$B.A:A,$C.A:A,$D.A:A,$E.A:A,$F.A:A,$G.A:A,$H.A:A,$I.A:A,$J.A:A,$K.A:A,$L.A:A,$M.A:A,$N.A:A,$O.A:A,$P.A:A,$Q.A:A,$R.A:A,$S.A:A,$T.A:A,$U.A:A,$V.A:A,$W.A:A,$X.A:A,$Y.A:A,$Z.A:A)
This is basically over and over $A.A:A. The $A is just the name of
the sheet with a dollarsign in front of it... then a period and the
A:A represents everything in column A
For the formula above to work the name of the different sheets would
need to be A B C... etc... if not, change the $A $B $C etc to
$sheet1 $sheet2 $sheet3...etc or whatever the name of your sheets
happen to be.
Brian Cluff
This shorter one may work as well.
=COUNTA($A.A:A:$W.A:A)
On 11/21/24 17:44, Michael via
PLUG-discuss wrote:
chapgpt doesn't know what it's talking about. how
do I count all entries in column A across all sheets in libre
calc? the sheets are A B C D E F G H I J K L M N
P R S T V W .
The formula it gives me is saying 20 when I know there is
over 100. Here is the formula it gives me: