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.
|