Is there a SUM-function equivalent to the FREQUENCY-function?
in c2 =b2
in c3 =b3+c2
copy c3 down
" wrote:
On 18 Mai, 13:52, vsoler wrote:
On 18 mayo, 13:42, wrote:
Instead of just counting the number of hits in the different intervals
using FREQUENCY, I want to summarize the values of these hits. I have
tried several logical functions in combination with SUMIF, but the
result so far is no good. Anyone who knows how to do this?
Regards,
John Martin
Could you explain a little more in detail what you are pretending?
Give an example
OK,
I have a sheet called 'data', where I have used the FREQUENCY-function
to analyze the content in column D and count how many hits there are
in several intervals.
On another sheet I have organized the Interval- and Result columns
like beneat:
Col. A Col. B
Interval Results
500000 2493
1000000 867
1500000 458
2000000 207
2500000 68
3000000 29
3500000 15
4000000 9
4500000 7
5000000 3
5000000 24
The formula i.e. cell B2 goes like this:
=FREQUENCY('Data'!D:D;Sheet2!A2:A11)
And then again this is set up as a matrix-function for range B2:B12 to
get the result as shown
However, I don't want to know just how many hits there are in the
different intervals, I also want to calculate the sum of these hits
and put the result i.e. in column C.
I hope that was informative :-)
Regards,
John Martin
|