Sumif condition

[pdberger]

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.

 

[Bob Phillips]

=SUMPRODUCT(--(LEFT(A1:A10,1)="*"),B1:B10)

 

[T. Valko]

Try this:

=SUMIF(A1:A10,"~**",B1:B10)

Or, if that's too cryptic:

=SUMPRODUCT(--(LEFT(A1:A10)="*"),B1:B10)