Thread: Sumif condition
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
pdberger pdberger is offline
external usenet poster
 
Posts: 258
Default 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.