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