Forum Discussion

Sachin_Bhangale's avatar
Sachin_Bhangale
Copper Contributor
Jul 09, 2020

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 :...
excel
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jul 09, 2020

Sachin_Bhangale 

As variant

=SUMPRODUCT(SUBSTITUTE(A1:A3,"O -","")*1)

and

=COUNTIF(A1:A7,"<>*O -*")*25
Sachin_Bhangale's avatar
Sachin_Bhangale
Copper Contributor
Jul 10, 2020
Thanks.
Your 2nd formula perfectly works for me. I got formula for 1 from another user.
Thanks.

Resources