Hi,

I need "Cumm Freq", sample data how I need it.

In the first column we have sequence of numbers, in second column I need to add up the above numbers from start of the column value.

I am giving the excel formula how I got it in Excel.

Col1 Cumm Freq (Excel Formula)
9 9 (=A1)
2 11 (=sum($A$1:A2))
4 15 (=sum($A$1:A3))
4 19 (=sum($A$1:A4))
4 23 so on......
10 33
3 36
1 37
7 44
9 53
11 64


Regards,
Sunil

This message has been edited. Last edited by: <Emily McAllister>,

OMG. I cant understand what you need.
Could you explain it better?

quote:

Originally posted by Ricardo Augusto:
OMG. I cant understand what you need.
Could you explain it better?

Hi Augusto,

I have updated the post, let me know if it is clear now.

Thank you,
Sunil

TRY COMPUTE CUMM_FREQ/D8 = COL1+ LAST CUMM_FREQ;

quote:

COMPUTE CUMM_FREQ/D8 = COL1+ LAST CUMM_FREQ;

Thank you very much Augusto...

It worked.

Regards,
Sunil

Hail FOCUS.

Welcome!

Could you please change the subject to SOLVED?

This message has been edited. Last edited by: Ricardo Augusto,