Is there a SUM-function equivalent to the FREQUENCY-function?
 

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

Is there a SUM-function equivalent to the FREQUENCY-function?
 

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

Is there a SUM-function equivalent to the FREQUENCY-function?
 

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

Is there a SUM-function equivalent to the FREQUENCY-function?
 

Insert a new row 2 and put 0 (zero) in A2. Then put this formula in
C3:

=SUMPRODUCT((Data!D1:D10000A2)*(Data!D1:D10000<=A 3)*(Data!D1:D10000))

and copy down to C12.

Hope this helps.

Pete

On May 18, 1:20 pm, 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

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

Is there a SUM-function equivalent to the FREQUENCY-function?
 

Thanks a lot!

Problem solved , case closed :-)


Regards,
John Martin