View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey
 
Posts: n/a
Default the answer to appear in more than one cell

Sorry, I know less than nothing about Works. You might try the

microsoft.public.works.win

newsgroup.


In article ,
LHorse wrote:

I copied the formula, made the change to cell reference and it says
not a valid works function, any suggestions?
B3: =INT((B$1-SUM(B$2:B2))/(8-ROW()))