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

[jmk]

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

 

[vsoler]

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

 

[jmk]

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;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

 

[Pete_UK]

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

=SUMPRODUCT((Data!D110000>A2)*(Data!D110000<=A3)*(Data!D110000))

and copy down to C12.

Hope this helps.

Pete

 

[Guest]

in c2 =b2
in c3 =b3+c2
copy c3 down

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

The formula i.e. cell B2 goes like this:
=FREQUENCY('Data'!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

 

[jmk]

Thanks a lot!

Problem solved , case closed


Regards,
John Martin