Dear Forum Members,
I hope everybody is having a great time. I have data present in column G. The sample of data from G2:5 is as below

1 for rent 15 for sale
16 for sale
8 for sale
4 for rent 1 for sale 1 Commercial

I want an excel formula which can extract values for rent, for sale and for commercial and add them.

Thanks in advance.