View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
oscarcounts oscarcounts is offline
external usenet poster
 
Posts: 8
Default sumif and wildcards

I column B I have code numbers, 4 and 5 digit. In column E I have
corresponding financial values. I want to sum values which correspond to
sections of code numbers. ie by reading the first two or three digits of
grouped code number.