Same value of cells

Hii guys,
uiupload
in the “unit” row some cells are same like 40NA. now i want to find the sum of gross amount to 40NA olny.

Hi @Arjun_Reddy

Check this

How to sum all values in a column of an excel/Datatable? - #9 by Mr_JDavey

Thanks
Ashwin.S