View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default copying down while changing columns

Hi Jan,

Am Wed, 20 Feb 2019 06:29:45 -0800 (PST) schrieb Daddy Sage:

In columns b I have 6 values, in column C I have 10 values and in column C I have 8 values.

If I enter the fomular in E2 and copy down it just counts everything ad zeroes.


perhaps I misunderstood your problem.
Have a look:
https://1drv.ms/x/s!AqMiGBK2qniTgeEvzHYYFajvtt5kWg


Regards
Claus B.
--
Windows10
Office 2016