RunningCount vs Running Sum

[khansen97]

I am trying to create a variable that will give me a runningsum of another variable. For some reason I keep getting an #ierr error when I put the formula in. However if I change the Runningsum to a runningcount my numbers return correctly.

I have a feeling I am doing something wrong. Does anybody know what I could possibly be doing?

Here is my runningsum:
=RunningSum(Sum(( If (<Days in Status for Buckets>)<=5 Then (<ID Count All>))ForEach<Days in Status for Buckets>))

And here is the runningcount(that works):
=RunningCount(Sum(( If (<Days in Status for Buckets>)<=5 Then (<ID Count All>))ForEach<Days in Status for Buckets>))

Any suggestions?

Thanks in advance