librecalc

Top Page
Attachments:
Message as email
+ (text/plain)
+ (text/html)
+ (text/plain)
Delete this message
Reply to this message
Author: Michael via PLUG-discuss
Date:  
CC: Michael, Main PLUG discussion list
Old-Topics: Re: rsync
Subject: librecalc
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:
To subscribe, unsubscribe, or to change your mail settings:
https://lists.phxlinux.org/mailman/listinfo/plug-discuss