how we find specific word from string in excel and compaire it.

  • Thread starter Thread starter Vishnu
  • Start date Start date
V

Vishnu

i have three fields like
Date description amount
1/2/9 Mobile bill 45
25/2/9 Lycatel (mobile) 5
27/2//9 Shopping (cloths) 50
28/2/9 Mobile service 15

I need sum of all amount which description "mobile",
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sumif function 1
How do I have excel highlight days before & after a date on a cale 2
Return a name in the same row 3
Sum of data between two dates - tried SUMIF and it returned "0" 2
Calculate End Date Using Start Date and No. of Days excluding specific days. 0
Lookup and average data in an unsorted list 1
Forcasting question 4
need help finding most common number and so on 2

Back
Top