COUNTA and OFFSET

[edwardpestian]

I have a range of Data: F8:CT8

I need to count every 3rd column in this range starting with F8.

I just need to count if there is data in the cell excluding zeros.

In other words F8 F9 F10 F11 F12 F13
12 17


I need to know if there is data in f8 and f11 and so forthe...

Expect result is 2

Thanks in advance.

Regards,

EP

 

[macropod]

hi EP,

Try:
=SUM(IF((MOD(COLUMN($F$8:$CT$8),3)=0)*($F$8:$CT$8<>0),1,))
as an array formula.

If non-0 text is also to be counted, use:
=SUM(IF((MOD(COLUMN($F$8:$CT$8),3)=0)*($F$8:$CT$8<>"")*($F$8:$CT$8<>0),1,))
also as an array formula.

Cheers

[MS MVP - Word]

 

[edwardpestian]

Worked perfect. Thanks for the help.

Regards,

EP