Thread: calculate sum in between 2 empty cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rick Rick is offline
external usenet poster
  
Posts: 334
Default calculate sum in between 2 empty cell
Hi Everyone,

I have a column of data, they are all 1s and some empty cell in between
them. i want to fill the empty cell with the sum of all the 1s until the next
empty cell.

Is it possible?

many Thx
Reply With QuoteReply With Quote