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)