E
excelFan
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
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