Thread: sumif
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
excelFan excelFan is offline
external usenet poster
 
Posts: 53
Default sumif

please help me

in column A the range Itm contains ticker like
A1 car.3
A2 mobile
A3 battery
A4 mobile.3
A5 mobile
A6 battery
A7 car
A8 mobile.1
A9 car
A10 mobile
and so on€¦up to over thousand item

in column B the range Amt contains numbers like
B1 -3,589
B2 2,587
B3 -489
B4 2,587
B5 -5,687
B6 1,178
B7 567
B8 -9,642
B9 44,330
B10 13,897

No problem to me to sum those items with the dot "."
for example =sumif(Itm,"*.3",Amt)

I need help please to sum amounts of those which do not have the dot "."
like the ( battery ) and ( mobile )
many thanks