View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rhianne Rhianne is offline
external usenet poster
 
Posts: 10
Default Formula: How do I create a "rolling" sum in excel?

I have a spreadsheet where I need to have a way in which to capture the
number of statements people agree with - this data is collected from a
seperate document. for example, if five people agree then I want to be able
to be able to hit "1" each time but to have the cell instantly add up how
many I have entered. I am sure there is a method to do this, but I have no
idea what the correct formual would be!

Cheers

Rhianne