View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
micro1000 via OfficeKB.com micro1000 via OfficeKB.com is offline
external usenet poster
 
Posts: 4
Default Count number of rows < Sumproduct

Hi Max,

do you have any idea how to make the index not count blank cells as 0????

Max wrote:
Welcome, glad you got it up there
HI Max, I succeeded using your formula with index. I only had to change a
,

[quoted text clipped - 3 lines]

Thank you very much.... :


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200901/1