Forum Discussion
Excel formula to count and sum when value changes?
As a newbie to VB and excel I am having problem with the following, any and all help greatly received: Cell A1 is being populated by a data feed and is frequently changing (every second) in value, b...
Use the formula combination =SUMIF(A2:A100,<>&A1,B2:B100) to calculate the cumulative sum when values change, or =COUNTIF(A2:A100,<>&A1) to count the number of changes.