Count in two columns
Maybe this?:
=SUMPRODUCT(--(LEN(A4:A7&B4:B7)0))
Does that help?
***********
Regards,
Ron
XL2002, WinXP
" wrote:
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
|