- In a new column, enter the formula "=SUMIF(A:A,"="&C1,B:B)-SUMIF(A:A,"="&D1,B:B)" in the first row of the column.
- Copy the formula down to the rest of the rows in the column.
The resulting values in the column will be the sums of the values in Row B that fall between the values in cells C and D for each row.
Here's a breakdown of the formula:
- The first part of the formula, "
SUMIF(A:A,"="&C1,B:B)", sums the values in Row B where the corresponding value in Row A is greater than or equal to the value in cell C1.
- The second part of the formula, "
SUMIF(A:A,"="&D1,B:B)", subtracts the sum of the values in Row B where the corresponding value in Row A is greater than or equal to the value in cell D1.
- The result is the sum of the values in Row B that fall between the values in cells C and D.
You can then use these resulting values to create your histogram-like plots.