Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif condition
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif condition
=SUMPRODUCT(--(LEFT(A1:A10,1)="*"),B1:B10)
-- __________________________________ HTH Bob "pdberger" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif condition
Try this:
=SUMIF(A1:A10,"~**",B1:B10) Or, if that's too cryptic: =SUMPRODUCT(--(LEFT(A1:A10)="*"),B1:B10) -- Biff Microsoft Excel MVP "pdberger" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |