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.

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.

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.