sumif function

V

Vishnu

i am giving following data.

Date Description Amount
1/2/09 Mobile bill £50
3/2/09 Lycatel (mobile) £10
3/3/09 Rent £200
4/2/09 service (mobile) £5

i need some of amount which contain word "mobile" in description. what i
need to do.
 
J

Jacob Skaria

Assuming you have data from row 2 to row20 ;;please try the below formula

=SUMIF(B2:B20,"*mobile*",C2:C20)

If this post helps click Yes
 

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

how we find specific word from string in excel and compaire it. 2
sum the current month 2
Help on IF (i think) 3
Count number of dates between a specified period of time 2
Error result for link formula 4
help with Sum in between dates 12
IF ARRAY with multiple conditions. 1
How to use SumProduct to count reference or something else? 3

Top