Forum Discussion
Sum Value of Multiple Ranges
Is there a formula/combo of formulas to use the depth ranges (blue) to sum the fractures (green) based on the depths (yellow)? Thanks!
The totals are bit low but that may be expected. I'm using the actual data you provided in the screen cap.
=LET(filtered,FILTER(freq_feet,(E2>=top_depth)*(F2<=bot_depth),0),SUM(filtered))