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@lists.phxlinux.org
To subscribe, unsubscribe, or to change your mail settings:
https://lists.phxlinux.org/mailman/listinfo/plug-discuss