Forum Discussion

Woody435's avatar
Woody435
Copper Contributor
Aug 18, 2022

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 the data could be 

 

10, 15, <1, ,<10, 20 to produce a result of 45?

 

Please help, I have been wrestling with this for years.

 

 

1 Reply

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor

    Woody435 Use the SUM function referencing to each individual cell it will ignore cells if they contain a text like "<1".

     

Resources