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
---------------------------------------------------
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
(text/plain)