Sumif condition

  • Thread starter Thread starter pdberger
  • Start date Start date
P

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.
 
Try this:

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

Or, if that's too cryptic:

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