librecalc

[Michael]

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~(-:
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.phxlinux.org/pipermail/plug-discuss/attachments/20241121/f6caa055/attachment.htm>