Forum Discussion
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...
try:
=SUM(--SUBSTITUTE(A1:A5,"<",""))
where A1:A5 is the range you need to sum
alternatively
=SUM(IF(ISNUMBER(A1:A5),A1:A5,--MID(A1:A5,2,99)))
in this case it will remove the 1st character if it isn't a number so ">999" would also become a number (999)