Hi,

Could someone teach me how to add numbers without prefix column.

A
1 @101
2 102
3 @103
4 104
-----------
6 106

I need a function that could add 102 and 104 and result 106. I tried with
SUMPRODUCT and it doesn't seem to work. Prefix "@" was setup in column A1
and A3 to atuo input. Please help out.

Thanks,
Boris