View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
edwardpestian
 
Posts: n/a
Default COUNT and OFFSET


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