Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumif function
If there is a specific keyword, like "expense", in column A and I need to
return all the values contained in another column, but several of the "expense" cells in column A have other words in the cell with it, is there anyway to search just on "expense" in the column A eventhough some of the cells have other words in it? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumif function
hi
you can use the wild card character star(*). =sumif(A2:A100,"*expence*",B2:B100) but you didn't say if the word expence was before, after or in the middle. 1 "expence*" for "expence A" 2 "*expence" for "big expence" 3 "*expence*" for "big expence A" meaning that you can use the wild card character several ways. number 3 above should pick them all up regards FSt1 "dannyboy8" wrote: If there is a specific keyword, like "expense", in column A and I need to return all the values contained in another column, but several of the "expense" cells in column A have other words in the cell with it, is there anyway to search just on "expense" in the column A eventhough some of the cells have other words in it? Thanks |
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 |