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).
<colgroup><col><col></colgroup><tbody>
</tbody>
So the Outcome I would like in separate columns:
1.002 0
1.005 1
1.010 3
etc
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).
1.002 | 0 |
1.005 | 0 |
1.005 | 1 |
1.005 | 0 |
1.01 | 0 |
1.01 | 1 |
1.01 | 0 |
1.01 | 0 |
1.01 | 0 |
1.01 | 0 |
1.01 | 0 |
1.01 | 0 |
1.01 | 0 |
1.01 | 0 |
1.01 | 0 |
1.01 | 0 |
1.01 | 1 |
1.01 | 1 |
1.01 | 0 |
1.01 | 0 |
1.02 | 0 |
1.02 | 0 |
1.02 | 0 |
1.02 | 0 |
<colgroup><col><col></colgroup><tbody>
</tbody>
So the Outcome I would like in separate columns:
1.002 0
1.005 1
1.010 3
etc