skrev i en meddelelse
oups.com...
I want to count non-blank cells in two columns, but count only one of
them if both are non-blank.
The following example would yield 4
4 t
3
5 y
u


One way:

=COUNTA(A2:B20)-SUMPRODUCT((A1:A20<"")*(B1:B20<""))


--
Best regards
Leo Heuser

Followup to newsgroup only please.