| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumif function
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sumif function
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 --------------- Jacob Skaria "Vishnu" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to nest a left function within a sumif function? | Excel Worksheet Functions | |||
| How do I use the TODAY function with the SUMIF function? | Excel Worksheet Functions | |||
| SUMIF Function Inside SUMPRODUCT Function | Excel Worksheet Functions | |||
| Can SUMIF function include AND function | Excel Worksheet Functions | |||
| SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions | |||
Linear Mode
