<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
If I understand what you are trying to do, try this:<br>
=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)<br>
<br>
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 <br>
<br>
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.<br>
<br>
Brian Cluff<br>
<br>
This shorter one may work as well.<br>
=COUNTA($A.A:A:$W.A:A)<br>
<br>
<div class="moz-cite-prefix">On 11/21/24 17:44, Michael via
PLUG-discuss wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAFRvunJJ4rnTc-MHUDBYfsDCcNxYo1XNriZCE3isbxXC+NEQ4w@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr">
<div dir="ltr">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 .
<div>The formula it gives me is saying 20 when I know there is
over 100. Here is the formula it gives me:</div>
<div>=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)</div>
</div>
<div>--</div>
<div dir="ltr" class="gmail_signature">
<div dir="ltr">
<div>
<div dir="ltr">
<div><span style="font-size:12.8px">:-)~MIKE~(-:</span><br>
</div>
</div>
</div>
</div>
</div>
</div>
<br>
<fieldset class="moz-mime-attachment-header"></fieldset>
<pre class="moz-quote-pre" wrap="">---------------------------------------------------
PLUG-discuss mailing list: <a class="moz-txt-link-abbreviated" href="mailto:PLUG-discuss@lists.phxlinux.org">PLUG-discuss@lists.phxlinux.org</a>
To subscribe, unsubscribe, or to change your mail settings:
<a class="moz-txt-link-freetext" href="https://lists.phxlinux.org/mailman/listinfo/plug-discuss">https://lists.phxlinux.org/mailman/listinfo/plug-discuss</a>
</pre>
</blockquote>
<br>
</body>
</html>