Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Good morning --
I want to create a sumif using the first character of a field. If the first character is an asterisk, then I want to sum another column in the row: A B 1 ABC 4.25 2 *ABC 5.25 3 DEF 6.25 The correct answer would be 5.25. It seems like I should be building a LEFT function into a SUMIF function, but can't quite get all the way there. TIA for any help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
SumIF for more than one condition | Excel Worksheet Functions | |||
Sumif, having two condition | Excel Worksheet Functions | |||
sumif with or< condition | Excel Discussion (Misc queries) | |||
sumif with or< condition | Excel Worksheet Functions | |||
sumif on more than one condition | Links and Linking in Excel |