Forum Discussion
MonicaPeppin
Oct 04, 2024Copper Contributor
Formula/Function for adding cells that have are less than values
Can someone assit me with which formula to use to add cells together that contain the less than symbol for numbers from lab analysis results? I have attached a snip it for reference. Need to kno...
Patrick2788
Oct 04, 2024Silver Contributor
A solution with BYROW:
=LET(
numbers, 1 * TEXTAFTER(matrix, "<", , , , matrix),
BYROW(numbers, SUM)
)Matrix being C7:G11