Forum Discussion
Sum excluding text
Hi team, Formula 1 : A1 : 10 A2 : 20 A3 : O - 15 A4 : 45 In A4, I need to get sum of A1:A3, excluding alphabets. Formula 2 : A1 : 10 A2 : 20 A3 : O - 15 A4 : A A5 : SL A6 :...
Thanks.
Your 2nd formula perfectly works for me. I got formula for 1 from another user.
Thanks.
Your 2nd formula perfectly works for me. I got formula for 1 from another user.
Thanks.
Sachin_Bhangale , you are welcome