COUNT and OFFSET

[edwardpestian]

I have a range of Data: F8:CT8

I need to count the 1st column in this data range with there being 3 columns.

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

[Biff]

Hi!

Try this:

=SUMPRODUCT(--(MOD(ROW(F8:F100),3)=2),--(F8:F100<>0),--(F8:F100<>""))

Adjust for the end of the range.

If you might insert new rows before the start of the range:

=SUMPRODUCT(--(MOD(ROW(F8:F100)-ROW(F8),3)=0),--(F8:F100<>0),--(F8:F100<>""))

Biff

"edwardpestian" <[email protected]>
wrote in message
news:[email protected]...
>
> I have a range of Data: F8:CT8
>
> I need to count the 1st column in this data range with there being 3
> columns.
>
> 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
>
>
> --
> edwardpestian
> ------------------------------------------------------------------------
> edwardpestian's Profile:
> http://www.excelforum.com/member.php...o&userid=33809
> View this thread: http://www.excelforum.com/showthread...hreadid=541381
>

[edwardpestian]

Changed ROW to COLUMN, and the Range to F8:CT8, and it worked like a charm.

Thanks for the help.

Regards

[Biff]

You're welcome. Thanks for the feedback!

Biff

"edwardpestian" <[email protected]>
wrote in message
news:[email protected]...
>
> Changed ROW to COLUMN, and the Range to F8:CT8, and it worked like a
> charm.
>
> Thanks for the help.
>
> Regards
>
>
> --
> edwardpestian
> ------------------------------------------------------------------------
> edwardpestian's Profile:
> http://www.excelforum.com/member.php...o&userid=33809
> View this thread: http://www.excelforum.com/showthread...hreadid=541381
>