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

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

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

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

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

Thanks a lot!

Problem solved , case closed :-)


Regards,
John Martin