Forum Discussion
Woody435
Aug 18, 2022Copper Contributor
Ignoring values in a sum list
Hi, I have to run sums on discrete cells in an analytical report. If the data is reported at below detectable level, they report it as <1 or <10 Thus how do I create a sum function where th...
Riny_van_Eekelen
Aug 18, 2022Platinum Contributor
Woody435 Use the SUM function referencing to each individual cell it will ignore cells if they contain a text like "<1".