SUMIF "next" MIN... How do you do without macros?

[slim6y]

I'll C&P a small amount of the data below, but this is what I am trying to do.

In column A there is a number between 1.002 and 1.900 which are grouped together. Then in column B there is a 1 or a zero (completely binary).

I want to Sum all the groups' B columns.

So for example, I have 16 lots of 1.010 where a total of 3 is in column B.

Then I want to move straight to 1.020 and get it to sum column B there too. And so on.

I figured I would use something like SUMIF(FILTER(.... But I am unsure how to get it to look for the minimum column A that has not already counted for. I would also like to Print in the column next to my "sumif" the number that is in column A.

Here is a small selection of the data (I have 2547 repetitions).
[TABLE="width: 156"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD="align: right"]1.002[/TD]
[TD="align: right"]0
[/TD]
[/TR]
[TR]
[TD="align: right"]1.005[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]1.005[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]1.005[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]1.01[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]1.01[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]1.01[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]1.01[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]1.01[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]1.01[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]1.01[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]1.01[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]1.01[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]1.01[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]1.01[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]1.01[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]1.01[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]1.01[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]1.01[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]1.01[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]1.02[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]1.02[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]1.02[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]1.02[/TD]
[TD="align: right"]0[/TD]
[/TR]
</tbody>[/TABLE]

So the Outcome I would like in separate columns:
1.002 0
1.005 1
1.010 3
etc

 

[slim6y]

It's OK, I worked it out
Seeing as column A is completely predictable (ie +0.01) I just added 0.01 to Column C. Then Countif and Sumif. Easy enough