librecalc

[Brian Cluff]

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:
> =COUNTA(a.a) + COUNTA(b.a) + COUNTA(c.a) + COUNTA(d.a) + COUNTA(e.a) + 
> COUNTA(f.a) + COUNTA(g.a) + COUNTA(h.a) + COUNTA(i.a) + COUNTA(j.a) + 
> COUNTA(k.a) + COUNTA(l.a) + COUNTA(m.a) + COUNTA(n.a) + COUNTA(p.a) + 
> COUNTA(r.a) + COUNTA(s.a) + COUNTA(t.a) + COUNTA(v.a) + COUNTA(w.a)
> --
> :-)~MIKE~(-:
>
> ---------------------------------------------------
> PLUG-discuss mailing list:PLUG-discuss at lists.phxlinux.org
> To subscribe, unsubscribe, or to change your mail settings:
> https://lists.phxlinux.org/mailman/listinfo/plug-discuss
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.phxlinux.org/pipermail/plug-discuss/attachments/20241121/63f5a918/attachment.htm>