Mar 14 2023 12:02 PM
Is there a formula/combo of formulas to use the depth ranges (blue) to sum the fractures (green) based on the depths (yellow)? Thanks!
Mar 14 2023 10:55 PM
Mar 14 2023 11:46 PM
How to count and sum cells based on background color in Excel?
Maybe these links will help you a bit further in your project.
Mar 15 2023 07:58 AM
Mar 15 2023 09:02 AM
=SUMPRODUCT(INDIRECT("C"&MATCH(1,($A$2:$A$12<=E2)*($B$2:$B$12>=E2),0)+1):INDIRECT("C"&MATCH(1,($A$2:$A$12<=F2)*($B$2:$B$12>=F2),0)+1))
Does this formula return the expected results in the simplified example? The formula has to be entered with ctrl+shift+enter if one doesn't work with Office 365 or Excel 2021.
Mar 15 2023 09:33 AM
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))