Aggregate query
 

I have 2 columns of numbers i.e delay and count
Delay Count
0.01 10
0.03 11
0.81 8
1,01 12
1,08 9
2.1 11

I would like to sum 2nd column according to the ranges eg
0 -.0.99 29
1 - 1.99 21
2.- 2.99 11

Is there a way to do this without highlighting the range and summing
manually?

Aggregate query
 

Try these 3 formula for your conditions:-

=SUMIF(A$1:A$6,"=0",B$1:B$6)-SUMIF(A$1:A$6,"=1",B$1:B$6)
=SUMIF(A$1:A$6,"=1",B$1:B$6)-SUMIF(A$1:A$6,"=1.99",B$1:B$6)
=SUMIF(A$1:A$6,"=2",B$1:B$6)-SUMIF(A$1:A$6,"=2.99",B$1:B$6)

Mike

"Hilton" wrote:

I have 2 columns of numbers i.e delay and count
Delay Count
0.01 10
0.03 11
0.81 8
1,01 12
1,08 9
2.1 11

I would like to sum 2nd column according to the ranges eg
0 -.0.99 29
1 - 1.99 21
2.- 2.99 11

Is there a way to do this without highlighting the range and summing
manually?

Aggregate query
 

Oops see correction below

1.99 should be 2
2.99 should be 3

Mike

"Mike H" wrote:

Try these 3 formula for your conditions:-

=SUMIF(A$1:A$6,"=0",B$1:B$6)-SUMIF(A$1:A$6,"=1",B$1:B$6)
=SUMIF(A$1:A$6,"=1",B$1:B$6)-SUMIF(A$1:A$6,"=2",B$1:B$6)
=SUMIF(A$1:A$6,"=2",B$1:B$6)-SUMIF(A$1:A$6,"=3",B$1:B$6)

Mike

"Hilton" wrote:

I have 2 columns of numbers i.e delay and count
Delay Count
0.01 10
0.03 11
0.81 8
1,01 12
1,08 9
2.1 11

I would like to sum 2nd column according to the ranges eg
0 -.0.99 29
1 - 1.99 21
2.- 2.99 11

Is there a way to do this without highlighting the range and summing
manually?