View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre Ron Coderre is offline
external usenet poster
 
Posts: 2,118
Default 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