that worked (I think). Thank you so much. I say 'think' because the answer
I got was 200. Odd to get a round number like that.
On Fri, Nov 22, 2024 at 2:03 PM Brian Cluff via PLUG-discuss <
plug-discuss@lists.phxlinux.org> wrote:
> 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
>
--
:-)~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
(text/plain)