Question: If I’m using an excel function like SUM or AVERAGE, is there a way to have it identify the range based on certain criteria (like a blank cell to the next blank cell for example) instead of having to explicitly telling it

Context: I’m doing some data analysis that involves measuring things from multiple region of interests (ROIs) in an image. I have lots of images each with variable numbers of ROIs but am trying to create a single number of the measurement for the image but some images have 10 ROIs where as some have closer to 100. Since I have a single row in between data sets for each image I’d like to be able to tell excel, find the sum (or avg)of all the measurements between the cell above it to the first blank cell it comes across, its this possible? I think it’d be kind of like doing a forloop but not sure if that’s exactly right or if its possible to do those in excel functions

I think it’d be similar to a countif function but instead of just counting the cells, it sums the numbers within the cells