Excel: Preparing Histogram Data

Question

I'd like to prepare data for a Histogram in Excel, and I dont know how.

I have a time series of measurements over a year. I know how to make a histogram on the number of measurements, but not how to make one on the measurement quantity, showing the measured quantity per time bin. So far I used the Frequency funtion

can you help me?

minimal example

Answer 1

I solved the problem when i discovered the syntax

"<"&F4   //dynamic inequality

for the criteria in SUMIFS(). Hence an easy solution: (and adding one more upper bin boundary)

thanks to cybernetic.nomad for making me re-consider SUMIFS(). i tried before but didnt succeed.